Shipping is free on all orders containing custom items! Any applicable taxes and duties are also included in the price.
Return Shipping is also free (first orders only). You are covered by our 100% satisfaction guarantee.
Need to make some adjustments for a perfect fit? We have you covered for a full year!
Go to any local tailor, email us a copy of the receipt and we will issue a refund of up to $125 per custom suit and $50 per ready-to-wear suit.
Our model is 6' and wears a 38R Coat. If you need any alterations, we'll cover up to $50 per coat - just email us the receipt.
A true classic, the light brown coat in a 95% wool & 5% cashmere blend by Bottoli feels light & soft. The coat will serve you well on cold autumn & winter days - the fabric is substantial, with a weight of 18 oz.
Our model is 6' and wears a 38R Coat. If you need any alterations, we'll cover up to $50 per coat - just email us the receipt.
A true classic, the light brown coat in a 95% wool & 5% cashmere blend by Bottoli feels light & soft. The coat will serve you well on cold autumn & winter days - the fabric is substantial, with a weight of 18 oz.
Learn moreThis coat features:
- Italian wool-cashmere by Bottoli.
- Unpadded shoulders.
- Non-functional sleeve cuffs.
- Three-button closure.
- Single vent.
- Pick Stitching.
- Full lining: breathable Italian cupro & rayon.
- High armholes for mobility & comfort.
- A timeless medium width notch lapel.
- A tapered waist.
- 100% European production & materials.
Size up for a comfortable fit over a jacket.
Order your usual size for a slim fit without a jacket.
Sign up to receive an email notification as soon as this product becomes available again.
You will receive a one time email when this product arrives in stock.
Most customers match jacket size xxx with pants with waist size xxx to xxx.
Тип | Файл | Ред | Съобщение |
---|---|---|---|
warning | /home/oliver/oliverwicks/library/Zfms/Controller/Plugin/LanguageLocaleUSD.php | 22 |
Attempt to read property "nLocaleID" on null |
warning | /home/oliver/oliverwicks/application/modules/eshop3/public/views/scripts/products/details.phtml | 734 |
Undefined array key 0 |
warning | /home/oliver/oliverwicks/library/Zend/View/Helper/Placeholder/Container/Standalone.php | 132 |
Array to string conversion |
warning | /home/oliver/oliverwicks/library/Zend/View/Helper/Placeholder/Container/Standalone.php | 132 |
Array to string conversion |
Номер № | Модул | Кеш ИД | Кеш Таг | Обект | Времетраене | Съобщение | |
---|---|---|---|---|---|---|---|
1 | eshop3 | eshop3 | eshop3_configs_dragon_routes_xml | eshop3_configs | Zend_Config_Xml | 0.589 ms |
Loaded from cache. |
2 | core | core | all_widgets_connections_65__mode_public__plugin | all_widgets | Array | 0.545 ms |
Loaded from cache. |
3 | core | core | core_configs_bootstrap_xml | core_configs | Zend_Config | 0.471 ms |
Loaded from cache. |
4 | api | api | api_scanmodels | scanModels | Array | 0.427 ms |
Saved in cache. |
5 | core | core | Zfms_Cache_Common | 0.381 ms |
Caching Enabled => Redis - Cache initialized! |
||
6 | core | core | public_acl_objacl | no tag available | Zend_Acl | 0.322 ms |
Loaded from cache. |
7 | core | core | core_configs_site_xml | core_configs | Zend_Config | 0.319 ms |
Loaded from cache. |
8 | eshop3 | eshop3 | eshop3_configs_main_ini | eshop3_configs | Zend_Config_Ini | 0.287 ms |
Loaded from cache. |
9 | eshop3 | eshop3 | eshop3_configs_history_xml | eshop3_configs | Zend_Config_Xml | 0.287 ms |
Loaded from cache. |
10 | content | content | content_configs_routes_xml | content_configs | Zend_Config | 0.227 ms |
Loaded from cache. |
11 | core | core | core_scanmodels | scanModels | Array | 0.222 ms |
Loaded from cache. |
12 | core | core | requestconnections_eshop3_products_details_0 | RequestConnections | Array | 0.215 ms |
Loaded from cache. |
13 | eshop3 | eshop3 | eshop3_configs_order_mail_xml | eshop3_configs | Zend_Config | 0.208 ms |
Loaded from cache. |
14 | core | core | core_configs_mail_xml | core_configs | Zend_Config | 0.195 ms |
Loaded from cache. |
15 | core | core | core_configs_routes_xml | core_configs | Zend_Config | 0.188 ms |
Loaded from cache. |
16 | menus | menus | menus_scanmodels | scanModels | Array | 0.16 ms |
Loaded from cache. |
17 | api | api | api_scanmodels | scanModels | Array | 0.136 ms |
Loaded from cache. |
18 | core | core | getseoplugin_4_1 | getSeoPlugin | Array | 0.128 ms |
Loaded from cache. |
19 | content | content | content_scanmodels | scanModels | Array | 0.124 ms |
Loaded from cache. |
20 | eshop3 | eshop3 | eshop3_scanmodels | scanModels | Array | 0.117 ms |
Loaded from cache. |
20 | Общо | 5.548 ms |
тип на заявка | време (ms) | завършена | заявка |
---|---|---|---|
CONNECT | 0.347 ms | 1 | connect |
QUERY | 0.076 ms | 1 | SET NAMES utf8 |
SELECT | 0.235 ms | 1 | SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = '4d14mi9pc6a3vhuqu0mcj4k6v8'))) |
SELECT | 0.093 ms | 1 | SELECT `l`.*, `ll`.`nUID` AS `nLocaleID`, `ll`.`sLocale` FROM `languages` AS `l` INNER JOIN `language_locales` AS `ll` ON l.nUID = ll.nLanguageID AND ll.nPublished = 1 AND ll.nDeleted = 0 WHERE (l.nDefault = 1) GROUP BY `l`.`nUID` ORDER BY `ll`.`nOrder` ASC LIMIT 1 |
SELECT | 0.521 ms | 1 | SELECT `ep`.* FROM `eshop3_products` AS `ep` INNER JOIN `eshop3_products_i18n` AS `epi` ON ep.nUID = epi.nProductID AND epi.nDeleted = 0 WHERE (epi.sUID = 'coat-in-brown-wool-cashmere') AND (epi.nLangId = 1) LIMIT 1 |
SELECT | 3.074 ms | 1 | SELECT `ep`.`nUID`, `ep`.`sStoreCode`, `ep`.`nInStock`, `ep`.`bIsAvailable`, `ep`.`nStatusFlags`, `ep`.`nProductPartID`, `ep`.`nRwSubtypeID`, `ep`.`nIsStarterKit`, `ep`.`bIsVotable`, `ep`.`sReverseRotation`, `epi`.`sName`, `epi`.`sNameRw`, `epi`.`sUID` AS `sProductUID`, `epi`.`sDescription`, `epi`.`sDescriptionRw`, `epi`.`sShortDescription`, `epci`.`sDescription` AS `sCommonDescription`, `epi`.`nLangID` AS `nLanguageID`, `ep`.`sVideoEmbed`, `ep`.`sVideoEmbedPhone`, `ep`.`isSignatureGrand`, `ep`.`nRequireMeasures`, `ep`.`nWeight`, `eprsi`.`sArticleLink`, `ep`.`nDeliveryDays`, `ep`.`nPaidShipping`, `ep`.`sExtension`, `ep`.`sExtensionVersion`, `ep`.`sThumbExtension`, `ep`.`sThumbExtensionVersion`, `ep`.`sHoverExtension`, `ep`.`sHoverExtensionVersion`, `ep`.`sBackExtension`, `ep`.`sBackExtensionVersion`, `ep`.`sBackZoomedExtension`, `ep`.`sBackZoomedExtensionVersion`, `eprs`.`sLogoExtension` AS `sRwSubtypeLogoExtension`, `eprs`.`sFeaturesExtension` AS `sRwSubtypeFeaturesExtension`, `eprs`.`sFeaturesMobileExtension` AS `sRwSubtypeFeaturesMobileExtension`, `epi`.`sMetaDescription`, `epi`.`sMetaKeywords`, `epi`.`sGAABTests`, `ep`.`nRecommendedCategory`, `ep`.`nAssociativeProduct`, `ep`.`dCreated` AS `productCreatedDate`, `ep`.`dModified` AS `productModifiedDate`, `eprii`.`nPrice`, `eprii`.`nCurrencyID`, `eprii1`.`nPrice` AS `nJacketPrice`, `eprii2`.`nPrice` AS `nVestPrice`, `eprii3`.`nPrice` AS `nPantsPrice`, `ecu`.`sLocale`, `ecu`.`sSymbol`, `ll`.`nUID` AS `nProductLocaleID`, `ed`.`dEndPeriod` AS `dDiscountEnd`, `ed`.`nUID` AS `nDiscountID`, `edd`.`sFormula` AS `sDiscount`, `et`.`nUID` AS `nTextileID`, `eti`.`sFabricDescriptionTitle`, `eti`.`sFabricDescriptionDetails`, `ecpn`.`nUID` AS `nCouponID`, `ecpn`.`sFormula` AS `sProductCoupon`, `ecpn`.`sProductPageDescription`, `ecpn`.`nShowCalculatedPrice` FROM `eshop3_products` AS `ep` INNER JOIN `eshop3_products_i18n` AS `epi` ON ep.nUID = epi.nProductID AND epi.nDeleted = 0 LEFT JOIN `eshop3_product_contents` AS `epc` ON ep.nContentID = epc.nUID AND epc.nPublished = 1 AND epc.nDeleted = 0 LEFT JOIN `eshop3_product_contents_i18n` AS `epci` ON epc.nUID = epci.nProductContentID AND epci.nDeleted = 0 INNER JOIN `eshop3_conn_product_prices` AS `ecpp` ON ep.nUID = ecpp.nProductID AND ecpp.nDeleted = 0 INNER JOIN `eshop3_prices` AS `epri` ON ecpp.nPriceID = epri.nUID AND epri.nDeleted = 0 INNER JOIN `eshop3_prices_data` AS `eprii` ON epri.nUID = eprii.nPriceID AND eprii.nDeleted = 0 LEFT JOIN `eshop3_prices` AS `epri_jacket` ON ep.nJacketPriceID = epri_jacket.nUID AND epri_jacket.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii1` ON epri_jacket.nUID = eprii1.nPriceID AND eprii1.nDeleted = 0 AND eprii1.nCurrencyID = eprii.nCurrencyID LEFT JOIN `eshop3_prices` AS `epri_vest` ON ep.nVestPriceID = epri_vest.nUID AND epri_vest.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii2` ON epri_vest.nUID = eprii2.nPriceID AND eprii2.nDeleted = 0 AND eprii2.nCurrencyID = eprii.nCurrencyID LEFT JOIN `eshop3_prices` AS `epri_pants` ON ep.nPantsPriceID = epri_pants.nUID AND epri_pants.nDeleted = 0 LEFT JOIN `eshop3_product_rw_subtypes` AS `eprs` ON ep.nRwSubtypeID = eprs.nUID AND eprs.nDeleted = 0 and eprs.nPublished = 1 LEFT JOIN `eshop3_product_rw_subtypes_i18n` AS `eprsi` ON eprs.nUID = eprsi.nProductRwSubtypeID AND eprs.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii3` ON epri_pants.nUID = eprii3.nPriceID AND eprii3.nDeleted = 0 AND eprii3.nCurrencyID = eprii.nCurrencyID INNER JOIN `eshop3_currencies` AS `ecu` ON eprii.nCurrencyID = ecu.nUID AND ecu.nPublished = 1 AND ecu.nDeleted = 0 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ecu.nUID = eccl.nCurrencyID AND eccl.nDeleted = 0 INNER JOIN `language_locales` AS `ll` ON eccl.nLanguageLocaleID = ll.nUID AND ll.nDeleted = 0 LEFT JOIN `eshop3_discounts` AS `ed` ON ecpp.nDiscountID = ed.nUID AND UNIX_TIMESTAMP(ed.dEndPeriod) >= UNIX_TIMESTAMP() AND ed.nPublished = 1 AND ed.nDeleted = 0 LEFT JOIN `eshop3_discounts_data` AS `edd` ON ed.nUID = edd.nDiscountID AND edd.nDeleted = 0 AND edd.nCurrencyID = ecu.nUID LEFT JOIN `eshop3_textiles` AS `et` ON ep.nTextileID = et.nUID AND et.nDeleted = 0 LEFT JOIN `eshop3_textiles_i18n` AS `eti` ON et.nUID = eti.nTextileID AND eti.nDeleted = 0 LEFT JOIN `eshop3_conn_coupon_category_products` AS `ecccp` ON ecccp.nUID = (SELECT `ecccp2`.`nUID` FROM `eshop3_conn_coupon_category_products` AS `ecccp2` INNER JOIN `eshop3_coupons` AS `ec2` ON ec2.nUID = ecccp2.nCouponID AND ec2.dStartPeriod <= NOW() AND ec2.dEndPeriod >= NOW() AND ec2.nDeleted = 0 AND ec2.nPublished = 1 AND ec2.sProductPageDescription IS NOT NULL AND ec2.nSecretSale = 0 WHERE (ecccp2.nProductID = ep.nUID) AND (ecccp2.nDeleted = 0) AND (ec2.nCurrencyID = ecu.nUID) ORDER BY `ec2`.`dEndPeriod` DESC LIMIT 1) LEFT JOIN `eshop3_coupons` AS `ecpn` ON ecccp.nCouponID = ecpn.nUID WHERE (ep.nDeleted = 0) AND (ep.nPublished = 1) AND (epi.sUID = 'coat-in-brown-wool-cashmere') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID) |
SELECT | 0.094 ms | 1 | SELECT `eci`.`sName` FROM `eshop3_categories_i18n` AS `eci` INNER JOIN `eshop3_conn_product_categories` AS `cpc` ON eci.nCategoryID = cpc.nCategoryID WHERE (cpc.nProductID = 1046) |
SELECT | 0.047 ms | 1 | SELECT `ypr`.* FROM `yotpo_product_reviews` AS `ypr` WHERE (productId = 1046) LIMIT 1 |
SELECT | 0.048 ms | 1 | SELECT `ecurr`.`nUID`, `ecurr`.`sSymbol`, `ell`.`sLocale` FROM `eshop3_currencies` AS `ecurr` INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ecurr.nUID = eccl.nCurrencyID AND eccl.nDeleted = 0 INNER JOIN `language_locales` AS `ell` ON eccl.nLanguageLocaleID = ell.nUID AND ell.nDeleted = 0 WHERE (ecurr.nDeleted = 0) AND (eccl.nLanguageLocaleID = 1) LIMIT 1 |
SELECT | 0.064 ms | 1 | SELECT `epi`.*, `epii`.`sCaption` FROM `eshop3_product_images` AS `epi` LEFT JOIN `eshop3_product_images_i18n` AS `epii` ON epi.nUID = epii.nProductImageID AND epii.nLangID = 1 AND epii.nDeleted = 0 WHERE (epi.nProductID = 1046) ORDER BY `nDefault` DESC, `nUID` ASC |
SELECT | 0.07 ms | 1 | SELECT `eppi`.* FROM `eshop3_product_phone_images` AS `eppi` WHERE (eppi.nProductID = 1046) ORDER BY `eppi`.`nOrder` ASC |
SELECT | 0.154 ms | 1 | SELECT `eppi`.* FROM `eshop3_product_panoramic_images` AS `eppi` WHERE (eppi.nProductID = 1046) ORDER BY `nUID` ASC |
SELECT | 1.202 ms | 1 | SELECT `ecpvp`.`nProductVariationID` AS `nUID`, `ecpvp`.`nDefault`, `epvi`.`sName`, `eprii`.`nPrice`, `eprii`.`nCurrencyID`, `ecu`.`sLocale`, `ecu`.`sSymbol`, `ll`.`nUID` AS `nProductLocaleID`, NULL AS `sDiscount`, NULL AS `dDiscountEnd` FROM `eshop3_products` AS `ep` INNER JOIN `eshop3_conn_product_variations_prices` AS `ecpvp` ON ep.nUID = ecpvp.nProductID AND ecpvp.nPriceID IS NOT NULL INNER JOIN `eshop3_product_variations` AS `epv` ON epv.nUID = ecpvp.nProductVariationID INNER JOIN `eshop3_product_variations_i18n` AS `epvi` ON epvi.nProductVariationID = epv.nUID LEFT JOIN `eshop3_conn_product_variations_options` AS `ecpvo` ON ecpvo.nProductVariationID = epv.nUID AND ecpvo.nDeleted = 0 INNER JOIN `eshop3_prices` AS `epri` ON ecpvp.nPriceID = epri.nUID AND epri.nDeleted = 0 INNER JOIN `eshop3_prices_data` AS `eprii` ON epri.nUID = eprii.nPriceID AND eprii.nDeleted = 0 INNER JOIN `eshop3_currencies` AS `ecu` ON eprii.nCurrencyID = ecu.nUID AND ecu.nPublished = 1 AND ecu.nDeleted = 0 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ecu.nUID = eccl.nCurrencyID AND eccl.nDeleted = 0 INNER JOIN `language_locales` AS `ll` ON eccl.nLanguageLocaleID = ll.nUID AND ll.nDeleted = 0 WHERE (ep.nDeleted = 0) AND (ep.nUID = 1046) AND (ll.nUID = 1) AND (epvi.nLangID = 1) GROUP BY `ecpvp`.`nProductVariationID` ORDER BY `epv`.`nOrder` ASC |
SELECT | 0.105 ms | 1 | SELECT `eprq`.`nProductID`, `eprq`.`nRwProductionOrderID`, `eprq`.`nSizeID`, `eprq`.`nMeasurePantLengthID`, `ems`.`sSize`, CASE WHEN sType = "pants" THEN CONCAT(ems.sSize, "W") WHEN sType = "jacket" THEN ems.sSize WHEN sType = "shoes" THEN ems.sSize WHEN sType = "vest" THEN ems.sSize END AS `sSizeText`, `eprq`.`sType`, `eprq`.`nQuantity`, `eprq`.`nQuantityForProduction`, `erwpo`.`dExpectedStock`, `erwpo`.`nUID` AS `nProductionOrderID`, `empl`.`nLength` FROM `eshop3_product_rw_quantity` AS `eprq` INNER JOIN `eshop3_measures_standard` AS `ems` ON eprq.nSizeID = ems.nUID and ems.nDeleted = 0 LEFT JOIN `eshop3_measures_pants_length` AS `empl` ON eprq.nMeasurePantLengthID = empl.nUID AND empl.nDeleted = 0 LEFT JOIN `eshop3_rw_production_orders` AS `erwpo` ON eprq.nRwProductionOrderID = erwpo.nUID AND erwpo.dInProduction IS NOT NULL AND erwpo.isReceivedInStock = 0 WHERE (eprq.nDeleted = 0) AND (eprq.nProductID IN (1046)) ORDER BY `eprq`.`nSizeID` ASC |
SELECT | 1.052 ms | 1 | SELECT `ecpp`.`nProductID`, `ecpp`.`nRelatedGroupID`, `ecpp`.`nProductConnID`, `ecpp`.`nOrder`, `ep`.`nInStock`, `epricesdata`.`nPrice`, `epricesdata`.`nCurrencyID`, `ecurrency`.`sLocale`, `ecurrency`.`sSymbol`, `ecclocales`.`nLanguageLocaleID`, `langlocale`.`sCountry`, `languages`.`sLanguage`, `epi`.`nLangID`, `epi`.`sName`, `ep`.`sThumbExtension`, `ep`.`nRequireMeasures` FROM `eshop3_conn_product_products` AS `ecpp` INNER JOIN `eshop3_products` AS `ep` ON ecpp.nProductConnID = ep.nUID AND ep.nPublished = 1 AND ep.nDeleted = 0 INNER JOIN `eshop3_products_i18n` AS `epi` ON ep.nUID = epi.nProductID AND ep.nDeleted = 0 INNER JOIN `eshop3_conn_product_prices` AS `ecpprices` ON ecpp.nProductConnID = ecpprices.nProductID AND ecpprices.nDeleted = 0 INNER JOIN `eshop3_prices` AS `eprices` ON ecpprices.nPriceID = eprices.nUID AND eprices.nDeleted = 0 INNER JOIN `eshop3_prices_data` AS `epricesdata` ON eprices.nUID = epricesdata.nPriceID AND epricesdata.nDeleted = 0 INNER JOIN `eshop3_currencies` AS `ecurrency` ON epricesdata.nCurrencyID = ecurrency.nUID AND ecurrency.nPublished = 1 AND ecurrency.nDeleted = 0 INNER JOIN `eshop3_conn_currency_locales` AS `ecclocales` ON ecurrency.nUID = ecclocales.nCurrencyID AND ecclocales.nDeleted = 0 INNER JOIN `language_locales` AS `langlocale` ON ecclocales.nLanguageLocaleID = langlocale.nUID AND langlocale.nPublished = 1 AND langlocale.nDeleted = 0 INNER JOIN `languages` ON langlocale.nLanguageID = languages.nUID AND languages.nPublished = 1 WHERE (ecpp.nDeleted = 0) AND (ecpp.nProductID = 1046) AND (ecpp.nOrder > 0) AND (ep.nInStock > 0) AND (epi.nLangID = languages.nUID) AND (languages.nUID = 1) AND (langlocale.nUID = 1) GROUP BY `ecpp`.`nRelatedGroupID` ORDER BY `ecpp`.`nRelatedGroupID` ASC |
SELECT | 0.075 ms | 1 | SELECT `ecc`.*, `ec`.`sName` FROM `eshop3_courier_charges` AS `ecc` INNER JOIN `eshop3_couriers` AS `ec` ON ec.nUID = ecc.nCourierID AND ecc.nDeleted = 0 INNER JOIN `language_locales` AS `ll` ON ec.nLocaleID = ll.nUID AND ll.nPublished = 1 AND ll.nDeleted = 0 WHERE (ecc.nDeleted = 0) AND (ll.nUID = 1) ORDER BY `ec`.`nOrder` ASC LIMIT 1 |
SELECT | 0.197 ms | 1 | SELECT VERSION() |
Общо време | 7.455 ms |
Executed queries | 17 |
---|---|
Total time in ms | 7.455 ms |
Longest query length | 3.074 ms |
Longest query | SELECT `ep`.`nUID`, `ep`.`sStoreCode`, `ep`.`nInStock`, `ep`.`bIsAvailable`, `ep`.`nStatusFlags`, `ep`.`nProductPartID`, `ep`.`nRwSubtypeID`, `ep`.`nIsStarterKit`, `ep`.`bIsVotable`, `ep`.`sReverseRotation`, `epi`.`sName`, `epi`.`sNameRw`, `epi`.`sUID` AS `sProductUID`, `epi`.`sDescription`, `epi`.`sDescriptionRw`, `epi`.`sShortDescription`, `epci`.`sDescription` AS `sCommonDescription`, `epi`.`nLangID` AS `nLanguageID`, `ep`.`sVideoEmbed`, `ep`.`sVideoEmbedPhone`, `ep`.`isSignatureGrand`, `ep`.`nRequireMeasures`, `ep`.`nWeight`, `eprsi`.`sArticleLink`, `ep`.`nDeliveryDays`, `ep`.`nPaidShipping`, `ep`.`sExtension`, `ep`.`sExtensionVersion`, `ep`.`sThumbExtension`, `ep`.`sThumbExtensionVersion`, `ep`.`sHoverExtension`, `ep`.`sHoverExtensionVersion`, `ep`.`sBackExtension`, `ep`.`sBackExtensionVersion`, `ep`.`sBackZoomedExtension`, `ep`.`sBackZoomedExtensionVersion`, `eprs`.`sLogoExtension` AS `sRwSubtypeLogoExtension`, `eprs`.`sFeaturesExtension` AS `sRwSubtypeFeaturesExtension`, `eprs`.`sFeaturesMobileExtension` AS `sRwSubtypeFeaturesMobileExtension`, `epi`.`sMetaDescription`, `epi`.`sMetaKeywords`, `epi`.`sGAABTests`, `ep`.`nRecommendedCategory`, `ep`.`nAssociativeProduct`, `ep`.`dCreated` AS `productCreatedDate`, `ep`.`dModified` AS `productModifiedDate`, `eprii`.`nPrice`, `eprii`.`nCurrencyID`, `eprii1`.`nPrice` AS `nJacketPrice`, `eprii2`.`nPrice` AS `nVestPrice`, `eprii3`.`nPrice` AS `nPantsPrice`, `ecu`.`sLocale`, `ecu`.`sSymbol`, `ll`.`nUID` AS `nProductLocaleID`, `ed`.`dEndPeriod` AS `dDiscountEnd`, `ed`.`nUID` AS `nDiscountID`, `edd`.`sFormula` AS `sDiscount`, `et`.`nUID` AS `nTextileID`, `eti`.`sFabricDescriptionTitle`, `eti`.`sFabricDescriptionDetails`, `ecpn`.`nUID` AS `nCouponID`, `ecpn`.`sFormula` AS `sProductCoupon`, `ecpn`.`sProductPageDescription`, `ecpn`.`nShowCalculatedPrice` FROM `eshop3_products` AS `ep` INNER JOIN `eshop3_products_i18n` AS `epi` ON ep.nUID = epi.nProductID AND epi.nDeleted = 0 LEFT JOIN `eshop3_product_contents` AS `epc` ON ep.nContentID = epc.nUID AND epc.nPublished = 1 AND epc.nDeleted = 0 LEFT JOIN `eshop3_product_contents_i18n` AS `epci` ON epc.nUID = epci.nProductContentID AND epci.nDeleted = 0 INNER JOIN `eshop3_conn_product_prices` AS `ecpp` ON ep.nUID = ecpp.nProductID AND ecpp.nDeleted = 0 INNER JOIN `eshop3_prices` AS `epri` ON ecpp.nPriceID = epri.nUID AND epri.nDeleted = 0 INNER JOIN `eshop3_prices_data` AS `eprii` ON epri.nUID = eprii.nPriceID AND eprii.nDeleted = 0 LEFT JOIN `eshop3_prices` AS `epri_jacket` ON ep.nJacketPriceID = epri_jacket.nUID AND epri_jacket.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii1` ON epri_jacket.nUID = eprii1.nPriceID AND eprii1.nDeleted = 0 AND eprii1.nCurrencyID = eprii.nCurrencyID LEFT JOIN `eshop3_prices` AS `epri_vest` ON ep.nVestPriceID = epri_vest.nUID AND epri_vest.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii2` ON epri_vest.nUID = eprii2.nPriceID AND eprii2.nDeleted = 0 AND eprii2.nCurrencyID = eprii.nCurrencyID LEFT JOIN `eshop3_prices` AS `epri_pants` ON ep.nPantsPriceID = epri_pants.nUID AND epri_pants.nDeleted = 0 LEFT JOIN `eshop3_product_rw_subtypes` AS `eprs` ON ep.nRwSubtypeID = eprs.nUID AND eprs.nDeleted = 0 and eprs.nPublished = 1 LEFT JOIN `eshop3_product_rw_subtypes_i18n` AS `eprsi` ON eprs.nUID = eprsi.nProductRwSubtypeID AND eprs.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii3` ON epri_pants.nUID = eprii3.nPriceID AND eprii3.nDeleted = 0 AND eprii3.nCurrencyID = eprii.nCurrencyID INNER JOIN `eshop3_currencies` AS `ecu` ON eprii.nCurrencyID = ecu.nUID AND ecu.nPublished = 1 AND ecu.nDeleted = 0 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ecu.nUID = eccl.nCurrencyID AND eccl.nDeleted = 0 INNER JOIN `language_locales` AS `ll` ON eccl.nLanguageLocaleID = ll.nUID AND ll.nDeleted = 0 LEFT JOIN `eshop3_discounts` AS `ed` ON ecpp.nDiscountID = ed.nUID AND UNIX_TIMESTAMP(ed.dEndPeriod) >= UNIX_TIMESTAMP() AND ed.nPublished = 1 AND ed.nDeleted = 0 LEFT JOIN `eshop3_discounts_data` AS `edd` ON ed.nUID = edd.nDiscountID AND edd.nDeleted = 0 AND edd.nCurrencyID = ecu.nUID LEFT JOIN `eshop3_textiles` AS `et` ON ep.nTextileID = et.nUID AND et.nDeleted = 0 LEFT JOIN `eshop3_textiles_i18n` AS `eti` ON et.nUID = eti.nTextileID AND eti.nDeleted = 0 LEFT JOIN `eshop3_conn_coupon_category_products` AS `ecccp` ON ecccp.nUID = (SELECT `ecccp2`.`nUID` FROM `eshop3_conn_coupon_category_products` AS `ecccp2` INNER JOIN `eshop3_coupons` AS `ec2` ON ec2.nUID = ecccp2.nCouponID AND ec2.dStartPeriod <= NOW() AND ec2.dEndPeriod >= NOW() AND ec2.nDeleted = 0 AND ec2.nPublished = 1 AND ec2.sProductPageDescription IS NOT NULL AND ec2.nSecretSale = 0 WHERE (ecccp2.nProductID = ep.nUID) AND (ecccp2.nDeleted = 0) AND (ec2.nCurrencyID = ecu.nUID) ORDER BY `ec2`.`dEndPeriod` DESC LIMIT 1) LEFT JOIN `eshop3_coupons` AS `ecpn` ON ecccp.nCouponID = ecpn.nUID WHERE (ep.nDeleted = 0) AND (ep.nPublished = 1) AND (epi.sUID = 'coat-in-brown-wool-cashmere') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID) |
Общо време за генериране всички mysql заявки | 7.455 ms |
---|---|
Общо време за генериране всичко от кеша | 5.548 ms |
Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко)) | 33.748 ms |