back

Fiat 500 Riva - Cabrio - LIMITED

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

Extra options:

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

video

General information

Year2017

made by Vergilio

  ZFDebug log Log variables Variables database 148 in 89.27 ms 9437K in 6309ms

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

337ms2601KStartup - ZFDebug construct()
21ms1587KRoute
184ms3725KproductsController::detailAction
249ms4545KDispatch
6309ms9053KShutdown

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 => 'it'
module => 'products'
rewrite_url => 'fiat-500-c-riva'

Zend Registry

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

Cookies

 

Database queries – Metadata cache ENABLED

0.40ms connect
0.58ms SELECT `products_folders`.*, `entities`.* FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id
0.15ms SELECT `products_folders`.`folder_id`, `products_folders`.`parent_id` FROM `products_folders`
1.99ms 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 = "it" 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 = "it" 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'fiat-500-c-riva') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.88ms 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 = "it" 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 = "it" 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.65ms 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it')
1.21ms 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (folder_id in (select folder_id from products_folders_associated where product_id = '451')) AND (folder_id in ('25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '83', '84', '85', '86')) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
7.89ms SELECT `products_folders`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = "it" 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 = "it" 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:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') ORDER BY `priority` ASC
2.08ms 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 = "it" 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 = "it" 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (products_folders_associated.folder_id = '27') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') ORDER BY `products_folders_associated`.`priority` ASC
0.71ms 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 68) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
2.74ms 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') ORDER BY `relation_priority` asc
1.73ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') ORDER BY `relation_priority` asc
1.65ms 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') ORDER BY `relation_priority` asc
1.40ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') ORDER BY `relation_priority` asc
0.62ms 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`template_id` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.15ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') ORDER BY `relation_priority` asc
0.12ms 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'it') 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 = "it" 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 = "it" 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'it') ORDER BY `relation_priority` asc
0.81ms 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`template_id` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it')
0.09ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 1)
0.56ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '34') LIMIT 1
0.09ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 2)
0.45ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.45ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '18') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '19') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 36) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'transer-speed') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '36') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 37) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'displacement-speed') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.11ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '37') LIMIT 1
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 3)
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.10ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '22') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '23') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 24) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'long-range-cruising-speed-at-11-5-knots') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
1.92ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '24') LIMIT 1
0.09ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 4)
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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '4') LIMIT 1
0.59ms 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 5) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.59ms 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'hull-length') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '5') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 6) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.38ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'waterline-length') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '6') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '7') LIMIT 1
1.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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.34ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '8') LIMIT 1
0.58ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
1.16ms 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '9') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 10) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'displacement-laden') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '10') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '11') LIMIT 1
0.50ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.41ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '12') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
1.00ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '13') LIMIT 1
0.38ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '20') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 38) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.62ms 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'gross-tonnage') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '38') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.38ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '39') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 42) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'draft-boat-fully-laden') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.81ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '42') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
2.90ms 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '44') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
1.50ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '45') LIMIT 1
1.91ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 5)
0.50ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 25) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'overall-height-from-keel-to-hard-top') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.29ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '25') LIMIT 1
2.01ms 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 26) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.47ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'minimum-transport-height-from-keel') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '26') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 27) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'bow-pulpit') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '27') LIMIT 1
0.51ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 28) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'stern-platform') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '28') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '29') LIMIT 1
0.52ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '30') LIMIT 1
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 35) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'hawse') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.11ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '35') LIMIT 1
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 43) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.41ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'propulsion') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '43') 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 = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 46) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'safety-equipment') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '46') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 47) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.47ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'homologation-category') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.11ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '47') LIMIT 1
0.16ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 6)
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 31) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'standard-version-displacement-of-the-yacht') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '31') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 32) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'overloading-the-yacht-by') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '32') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 33) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'top-speed-decreases-of') AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '33') LIMIT 1
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 1)
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 1)
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '14') LIMIT 1
0.38ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '16') LIMIT 1
1.16ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "it" 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 = "it" 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 = "it" 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
11.77ms 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 = "it" 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 = "it" 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 = "it" 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 = "it" 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:01')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:01')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') ORDER BY `priority` ASC
0.26ms 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 = "it" 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 = "it" 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 = "it" 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1
0.14ms 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 = "it" 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 = "it" 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 = "it" 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 = "it" 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 = 'it') AND (ebl.entity_id IS NULL OR ebl.lang != 'it') LIMIT 1