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.
This suit is also available for custom orders.
Our model is 6'3" and wears a 40L jacket (waist taken in an additional 2", sleeve shortened 0.5") and a size 31W x 32L pant. If you need any alterations, we'll cover up to $50 per suit - just email us the receipt.
The Q. Suit in Solid Grey Wool is the definition of upscale nonchalance. Why upscale? Once you touch that Super 140s wool, woven by Angelico in Italy, you will surely be able to answer that yourself.
This suit is also available for custom orders.
Our model is 6'3" and wears a 40L jacket (waist taken in an additional 2", sleeve shortened 0.5") and a size 31W x 32L pant. If you need any alterations, we'll cover up to $50 per suit - just email us the receipt.
The Q. Suit in Solid Grey Wool is the definition of upscale nonchalance. Why upscale? Once you touch that Super 140s wool, woven by Angelico in Italy, you will surely be able to answer that yourself.
Learn moreThis suit features:
- 100% Italian Merino wool by Angelico. Light-weight all seasonal (240 gms / 8 oz).
- Half-canvas construction for an excellent lapel roll.
- Our Tailored cut with a tapered waist & modern, but balanced silhouette.
- High armholes for mobility & comfort.
- Lightly padded shoulders.
- A timeless medium width notch lapel.
- Two-button closure.
- A tapered waist.
- Double vent.
- Full lining: breathable Italian cupro & rayon. Lining color may vary.
- Pick Stitching.
- Boutonniere.
- Flat front trousers with moderate tapering below the knee.
- 100% European production & materials.
Modern fit. Go one size down for a slim fit.
Modern fit. Go one size down for a slim fit.
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.851 ms |
Loaded from cache. |
2 | core | core | all_widgets_connections_65__mode_public__plugin | all_widgets | Array | 0.678 ms |
Loaded from cache. |
3 | api | api | api_scanmodels | scanModels | Array | 0.467 ms |
Saved in cache. |
4 | core | core | core_configs_bootstrap_xml | core_configs | Zend_Config | 0.454 ms |
Loaded from cache. |
5 | core | core | Zfms_Cache_Common | 0.449 ms |
Caching Enabled => Redis - Cache initialized! |
||
6 | core | core | public_acl_objacl | no tag available | Zend_Acl | 0.428 ms |
Loaded from cache. |
7 | eshop3 | eshop3 | eshop3_configs_main_ini | eshop3_configs | Zend_Config_Ini | 0.413 ms |
Loaded from cache. |
8 | core | core | core_configs_mail_xml | core_configs | Zend_Config | 0.367 ms |
Loaded from cache. |
9 | content | content | content_configs_routes_xml | content_configs | Zend_Config | 0.35 ms |
Loaded from cache. |
10 | core | core | requestconnections_eshop3_products_details_0 | RequestConnections | Array | 0.335 ms |
Loaded from cache. |
11 | eshop3 | eshop3 | eshop3_configs_history_xml | eshop3_configs | Zend_Config_Xml | 0.317 ms |
Loaded from cache. |
12 | core | core | core_configs_routes_xml | core_configs | Zend_Config | 0.287 ms |
Loaded from cache. |
13 | eshop3 | eshop3 | eshop3_configs_order_mail_xml | eshop3_configs | Zend_Config | 0.28 ms |
Loaded from cache. |
14 | core | core | core_configs_site_xml | core_configs | Zend_Config | 0.277 ms |
Loaded from cache. |
15 | core | core | core_scanmodels | scanModels | Array | 0.226 ms |
Loaded from cache. |
16 | menus | menus | menus_scanmodels | scanModels | Array | 0.212 ms |
Loaded from cache. |
17 | core | core | getseoplugin_4_1 | getSeoPlugin | Array | 0.189 ms |
Loaded from cache. |
18 | eshop3 | eshop3 | eshop3_scanmodels | scanModels | Array | 0.18 ms |
Loaded from cache. |
19 | api | api | api_scanmodels | scanModels | Array | 0.168 ms |
Loaded from cache. |
20 | content | content | content_scanmodels | scanModels | Array | 0.164 ms |
Loaded from cache. |
20 | Общо | 7.092 ms |
тип на заявка | време (ms) | завършена | заявка |
---|---|---|---|
CONNECT | 0.347 ms | 1 | connect |
QUERY | 0.076 ms | 1 | SET NAMES utf8 |
SELECT | 0.38 ms | 1 | SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'rt656f7g61n20jb9lp1tc0oa8b'))) |
SELECT | 0.107 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.58 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 = 'suit-in-solid-grey-wool') AND (epi.nLangId = 1) LIMIT 1 |
SELECT | 6.635 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 = 'suit-in-solid-grey-wool') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID) |
SELECT | 0.427 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 = 760) |
SELECT | 0.141 ms | 1 | SELECT `ypr`.* FROM `yotpo_product_reviews` AS `ypr` WHERE (productId = 760) LIMIT 1 |
SELECT | 0.061 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.357 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 = 760) ORDER BY `nDefault` DESC, `nUID` ASC |
SELECT | 0.222 ms | 1 | SELECT `eppi`.* FROM `eshop3_product_phone_images` AS `eppi` WHERE (eppi.nProductID = 760) ORDER BY `eppi`.`nOrder` ASC |
SELECT | 0.322 ms | 1 | SELECT `eppi`.* FROM `eshop3_product_panoramic_images` AS `eppi` WHERE (eppi.nProductID = 760) ORDER BY `nUID` ASC |
SELECT | 0.844 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 = 760) AND (ll.nUID = 1) AND (epvi.nLangID = 1) GROUP BY `ecpvp`.`nProductVariationID` ORDER BY `epv`.`nOrder` ASC |
SELECT | 4.308 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 (760)) ORDER BY `eprq`.`nSizeID` ASC |
SELECT | 0.79 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 = 760) 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.211 ms | 1 | SELECT VERSION() |
Общо време | 15.884 ms |
Executed queries | 17 |
---|---|
Total time in ms | 15.884 ms |
Longest query length | 6.635 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 = 'suit-in-solid-grey-wool') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID) |
Общо време за генериране всички mysql заявки | 15.884 ms |
---|---|
Общо време за генериране всичко от кеша | 7.092 ms |
Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко)) | 47.414 ms |