Back

Blue Natural Stretch Suit

Whether you’re flying to the most important business meeting of your life, or catching a cab to join your friends at the Jazz Club, this anti-wrinkle fabric by VBC will get you there looking like a crisp dollar bill. Comfort, style and sophistication – this 3-ply triple twisted weave has got your back, no matter what time zone you find yourself in.

Learn more

Customize now

FREE SHIPPING & RETURNS Tailored and delivered by October 24.

CUSTOM MADE FOR YOU Get your measurements in just Get measured in 15 minutes following our videos. Have no fear! We will carefully review the numbers.

3 PLY NATURAL STRETCH WOOL Mid-weight all seasonal high twist wool (10 oz) with natural stretch. Woven in Italy by Vitale Barberis Canonico.

100% SATISFACTION GUARANTEE Alterations are covered for 365 days - up to $125 per suit at your local tailor! You can also return for a full refund or request a remake within 30 days of delivery.

Blue Natural Stretch Suit - slider image 1

Blue Natural Stretch Suit - slider image 2

Тип	Файл	Ред	Съобщение
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

Тип

Файл

Ред

Съобщение

warning

/home/oliver/oliverwicks/library/Zfms/Controller/Plugin/LanguageLocaleUSD.php

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.903 ms	Loaded from cache.
2	core	core	all_widgets_connections_65__mode_public__plugin	all_widgets	Array	0.722 ms	Loaded from cache.
3	core	core	core_configs_bootstrap_xml	core_configs	Zend_Config	0.605 ms	Loaded from cache.
4	api	api	api_scanmodels	scanModels	Array	0.598 ms	Saved in cache.
5	core	core			Zfms_Cache_Common	0.497 ms	Caching Enabled => Redis - Cache initialized!
6	eshop3	eshop3	eshop3_configs_main_ini	eshop3_configs	Zend_Config_Ini	0.449 ms	Loaded from cache.
7	core	core	public_acl_objacl	no tag available	Zend_Acl	0.405 ms	Loaded from cache.
8	content	content	content_configs_routes_xml	content_configs	Zend_Config	0.336 ms	Loaded from cache.
9	eshop3	eshop3	eshop3_configs_order_mail_xml	eshop3_configs	Zend_Config	0.328 ms	Loaded from cache.
10	core	core	requestconnections_eshop3_products_details_0	RequestConnections	Array	0.319 ms	Loaded from cache.
11	core	core	core_configs_routes_xml	core_configs	Zend_Config	0.313 ms	Loaded from cache.
12	eshop3	eshop3	eshop3_configs_history_xml	eshop3_configs	Zend_Config_Xml	0.309 ms	Loaded from cache.
13	core	core	core_configs_mail_xml	core_configs	Zend_Config	0.299 ms	Loaded from cache.
14	core	core	core_configs_site_xml	core_configs	Zend_Config	0.286 ms	Loaded from cache.
15	eshop3	eshop3	eshop3_configs_zo_products_xml	eshop3_configs	Zend_Config	0.267 ms	Loaded from cache.
16	menus	menus	menus_scanmodels	scanModels	Array	0.25 ms	Loaded from cache.
17	eshop3	eshop3	eshop3_configs_zo_products_xml	eshop3_configs	Zend_Config	0.219 ms	Loaded from cache.
18	eshop3	eshop3	eshop3_scanmodels	scanModels	Array	0.215 ms	Loaded from cache.
19	core	core	core_scanmodels	scanModels	Array	0.197 ms	Loaded from cache.
20	content	content	content_scanmodels	scanModels	Array	0.191 ms	Loaded from cache.
21	api	api	api_scanmodels	scanModels	Array	0.184 ms	Loaded from cache.
22	core	core	getseoplugin_4_1	getSeoPlugin	Array	0.146 ms	Loaded from cache.
22					Общо	8.038 ms

Номер №

Модул

Кеш ИД

Кеш Таг

Обект

Времетраене

Съобщение

eshop3

eshop3_configs_dragon_routes_xml

eshop3_configs

Zend_Config_Xml

0.903 ms

Loaded from cache.

core

all_widgets_connections_65__mode_public__plugin

all_widgets

Array

0.722 ms

Loaded from cache.

core

core_configs_bootstrap_xml

core_configs

Zend_Config

0.605 ms

Loaded from cache.

api

api_scanmodels

scanModels

Array

0.598 ms

Saved in cache.

core

Zfms_Cache_Common

0.497 ms

Caching Enabled => Redis - Cache initialized!

eshop3

eshop3_configs_main_ini

eshop3_configs

Zend_Config_Ini

0.449 ms

Loaded from cache.

core

public_acl_objacl

no tag available

Zend_Acl

0.405 ms

Loaded from cache.

content

content_configs_routes_xml

content_configs

Zend_Config

0.336 ms

Loaded from cache.

eshop3

eshop3_configs_order_mail_xml

eshop3_configs

Zend_Config

0.328 ms

Loaded from cache.

core

requestconnections_eshop3_products_details_0

RequestConnections

Array

0.319 ms

Loaded from cache.

core

core_configs_routes_xml

core_configs

Zend_Config

0.313 ms

Loaded from cache.

eshop3

eshop3_configs_history_xml

eshop3_configs

Zend_Config_Xml

0.309 ms

Loaded from cache.

core

core_configs_mail_xml

core_configs

Zend_Config

0.299 ms

Loaded from cache.

core

core_configs_site_xml

core_configs

Zend_Config

0.286 ms

Loaded from cache.

eshop3

eshop3_configs_zo_products_xml

eshop3_configs

Zend_Config

0.267 ms

Loaded from cache.

menus

menus_scanmodels

scanModels

Array

0.25 ms

Loaded from cache.

eshop3

eshop3_configs_zo_products_xml

eshop3_configs

Zend_Config

0.219 ms

Loaded from cache.

eshop3

eshop3_scanmodels

scanModels

Array

0.215 ms

Loaded from cache.

core

core_scanmodels

scanModels

Array

0.197 ms

Loaded from cache.

content

content_scanmodels

scanModels

Array

0.191 ms

Loaded from cache.

api

api_scanmodels

scanModels

Array

0.184 ms

Loaded from cache.

core

getseoplugin_4_1

getSeoPlugin

Array

0.146 ms

Loaded from cache.

Общо

8.038 ms

тип на заявка	време (ms)	завършена	заявка
CONNECT	0.47 ms	1	connect
QUERY	0.088 ms	1	SET NAMES utf8
SELECT	0.305 ms	1	SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'pgosi044gs9ei6bi1iulc0cln6')))
SELECT	0.123 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.191 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 = 'blue-natural-stretch-suit') AND (epi.nLangId = 1) LIMIT 1
SELECT	1.91 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 = 'blue-natural-stretch-suit') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID)
SELECT	0.102 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 = 1217)
SELECT	0.07 ms	1	SELECT `ypr`.* FROM `yotpo_product_reviews` AS `ypr` WHERE (productId = 1217) LIMIT 1
SELECT	0.051 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.098 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 = 1217) ORDER BY `nDefault` DESC, `nUID` ASC
SELECT	0.054 ms	1	SELECT `eppi`.* FROM `eshop3_product_phone_images` AS `eppi` WHERE (eppi.nProductID = 1217) ORDER BY `eppi`.`nOrder` ASC
SELECT	0.045 ms	1	SELECT `eppi`.* FROM `eshop3_product_panoramic_images` AS `eppi` WHERE (eppi.nProductID = 1217) ORDER BY `nUID` ASC
SELECT	0.057 ms	1	SELECT `erc`.* FROM `eshop3_recommended_categories` AS `erc` WHERE (erc.nDeleted = 0) AND (erc.nUID = 2) AND (erc.nPublished = 1) LIMIT 1
SELECT	0.19 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 = 1217) AND (ll.nUID = 1) AND (epvi.nLangID = 1) GROUP BY `ecpvp`.`nProductVariationID` ORDER BY `epv`.`nOrder` ASC
SELECT	0.173 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 = 1217) 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.104 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.068 ms	1	SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)
SELECT	0.87 ms	1	SELECT `ecpog`.`nOptionGroupID`, `eog`.`sName`, `eog`.`sDescription`, `eog`.`nSpecial`, `eog`.`nOrder` FROM `eshop3_conn_product_option_groups` AS `ecpog` INNER JOIN `eshop3_option_groups` AS `eog` ON ecpog.nOptionGroupID = eog.nUID AND eog.nPublished = 1 AND eog.nDeleted = 0 INNER JOIN `eshop3_options` AS `eo` ON eog.nUID = eo.nOptionGroupID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (ecpog.nDeleted = 0) AND (ecpog.nDeleted = 0) AND (ecpog.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) GROUP BY `ecpog`.`nOptionGroupID` ORDER BY `eog`.`nOrder` ASC
SELECT	0.073 ms	1	SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)
SELECT	0.062 ms	1	SELECT `ecpog`.`nOptionGroupID`, `eog`.`sName`, `eog`.`sDescription`, `eog`.`nSpecial`, `eog`.`nOrder` FROM `eshop3_conn_product_option_groups` AS `ecpog` INNER JOIN `eshop3_option_groups` AS `eog` ON ecpog.nOptionGroupID = eog.nUID AND eog.nPublished = 1 AND eog.nDeleted = 0 INNER JOIN `eshop3_options` AS `eo` ON eog.nUID = eo.nOptionGroupID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (ecpog.nDeleted = 0) AND (ecpog.nDeleted = 0) AND (ecpog.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) GROUP BY `ecpog`.`nOptionGroupID` ORDER BY `eog`.`nOrder` ASC
SELECT	0.052 ms	1	SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)
SELECT	0.091 ms	1	SELECT `eoi`.`sName`, `eoi`.`sUnit`, `eoi`.`sDescription`, `eo`.`nUID`, `eo`.`nOptionGroupID`, `eo`.`sClass`, `eo`.`nOrder` FROM `eshop3_options_i18n` AS `eoi` INNER JOIN `eshop3_options` AS `eo` ON eoi.nOptionID = eo.nUID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (eoi.nDeleted = 0) AND (IFNULL(eoi.nLangID, '1') = '1') AND (eoi.nLangID = 1) AND (eo.nOptionGroupID = '1') ORDER BY `eo`.`nOrder` ASC
SELECT	1.845 ms	1	SELECT `epov`.`nProductID`, `epov`.`nTypeID`, `epov`.`nOptionID`, `epov`.`nPriceID`, `epov`.`sValue`, `epov`.`nDefault`, `epov`.`sFormula`, `ec`.`sLocale`, `ec`.`sSymbol`, `epd`.`nPrice` AS `price`, `eor`.`sExtension`, `eor`.`nOrder`, `eor`.`isCommentEnabled`, `eoi`.`nUID`, `eoi`.`sDescription`, `eoi`.`sValue`, `eoi`.`nOptionRadioID`, `eoi`.`sCommentLabel`, `eoi`.`sDefaultTextLabel`, `eop`.`sName` AS `sProperty` FROM `eshop3_product_options_values` AS `epov` INNER JOIN `language_locales` AS `ll` ON ll.nPublished = 1 AND ll.nDeleted = 0 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ll.nUID = eccl.nLanguageLocaleID AND eccl.nDeleted = 0 INNER JOIN `languages` AS `l` ON ll.nLanguageID = l.nUID LEFT JOIN `eshop3_currencies` AS `ec` ON eccl.nCurrencyID = ec.nUID LEFT JOIN `eshop3_prices_data` AS `epd` ON epd.nPriceID = epov.nPriceID AND epd.nCurrencyID = eccl.nCurrencyID INNER JOIN `eshop3_options` AS `eo` ON epov.nTypeID = eo.nUID AND eo.sClass = 'Zfms_Option_Radio' AND eo.nDeleted = 0 INNER JOIN `eshop3_option_radios` AS `eor` ON eo.nUID = eor.nOptionID AND eor.nPublished = 1 AND eor.nDeleted = 0 INNER JOIN `eshop3_option_radios_i18n` AS `eoi` ON eor.nUID = eoi.nOptionRadioID AND eoi.nLangID = l.nUID AND eoi.nOptionRadioID IN (epov.nValueID) AND eoi.nDeleted = 0 LEFT JOIN `eshop3_option_properties` AS `eop` ON eoi.nPropertyID = eop.nUID AND eop.nDeleted = 0 WHERE (epov.nDeleted = 0) AND (eo.nOptionGroupID = '1') AND (epov.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) AND (ll.nUID = 1) ORDER BY `eor`.`nOrder` ASC
SELECT	0.083 ms	1	SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)
SELECT	0.063 ms	1	SELECT `eoi`.`sName`, `eoi`.`sUnit`, `eoi`.`sDescription`, `eo`.`nUID`, `eo`.`nOptionGroupID`, `eo`.`sClass`, `eo`.`nOrder` FROM `eshop3_options_i18n` AS `eoi` INNER JOIN `eshop3_options` AS `eo` ON eoi.nOptionID = eo.nUID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (eoi.nDeleted = 0) AND (IFNULL(eoi.nLangID, '1') = '1') AND (eoi.nLangID = 1) AND (eo.nOptionGroupID = '2') ORDER BY `eo`.`nOrder` ASC
SELECT	1.302 ms	1	SELECT `epov`.`nProductID`, `epov`.`nTypeID`, `epov`.`nOptionID`, `epov`.`nPriceID`, `epov`.`sValue`, `epov`.`nDefault`, `epov`.`sFormula`, `ec`.`sLocale`, `ec`.`sSymbol`, `epd`.`nPrice` AS `price`, `eoc`.`sExtension`, `eoc`.`nOrder`, `eoc`.`isCommentEnabled`, `eoi`.`nUID`, `eoi`.`sValue`, `eoi`.`nOptionCheckboxID`, `eoi`.`sDescription`, `eoi`.`sCommentLabel`, `eoi`.`sDefaultTextLabel` FROM `eshop3_product_options_values` AS `epov` INNER JOIN `language_locales` AS `ll` ON ll.nPublished = 1 AND ll.nDeleted = 0 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ll.nUID = eccl.nLanguageLocaleID AND eccl.nDeleted = 0 INNER JOIN `languages` AS `l` ON ll.nLanguageID = l.nUID LEFT JOIN `eshop3_currencies` AS `ec` ON eccl.nCurrencyID = ec.nUID LEFT JOIN `eshop3_prices_data` AS `epd` ON epd.nPriceID = epov.nPriceID AND epd.nCurrencyID = eccl.nCurrencyID INNER JOIN `eshop3_options` AS `eo` ON epov.nTypeID = eo.nUID AND eo.sClass = 'Zfms_Option_Checkbox' AND eo.nDeleted = 0 INNER JOIN `eshop3_option_checkboxes` AS `eoc` ON eo.nUID = eoc.nOptionID AND eoc.nPublished = 1 AND eoc.nDeleted = 0 INNER JOIN `eshop3_option_checkboxes_i18n` AS `eoi` ON eoc.nUID = eoi.nOptionCheckboxID AND eoi.nLangID = l.nUID AND eoi.nOptionCheckboxID IN (epov.nValueID) AND eoi.nDeleted = 0 WHERE (epov.nDeleted = 0) AND (eo.nOptionGroupID = '2') AND (epov.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) AND (ll.nUID = 1) ORDER BY `eoc`.`nOrder` ASC
SELECT	0.218 ms	1	SELECT VERSION()
Общо време	8.759 ms

тип на заявка

време (ms)

завършена

заявка

CONNECT

0.47 ms

connect

QUERY

0.088 ms

SET NAMES utf8

SELECT

0.305 ms

SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'pgosi044gs9ei6bi1iulc0cln6')))

SELECT

0.123 ms

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.191 ms

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 = 'blue-natural-stretch-suit') AND (epi.nLangId = 1) LIMIT 1

SELECT

1.91 ms

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 = 'blue-natural-stretch-suit') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID)

SELECT

0.102 ms

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 = 1217)

SELECT

0.07 ms

SELECT `ypr`.* FROM `yotpo_product_reviews` AS `ypr` WHERE (productId = 1217) LIMIT 1

SELECT

0.051 ms

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.098 ms

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 = 1217) ORDER BY `nDefault` DESC, `nUID` ASC

SELECT

0.054 ms

SELECT `eppi`.* FROM `eshop3_product_phone_images` AS `eppi` WHERE (eppi.nProductID = 1217) ORDER BY `eppi`.`nOrder` ASC

SELECT

0.045 ms

SELECT `eppi`.* FROM `eshop3_product_panoramic_images` AS `eppi` WHERE (eppi.nProductID = 1217) ORDER BY `nUID` ASC

SELECT

0.057 ms

SELECT `erc`.* FROM `eshop3_recommended_categories` AS `erc` WHERE (erc.nDeleted = 0) AND (erc.nUID = 2) AND (erc.nPublished = 1) LIMIT 1

SELECT

0.19 ms

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 = 1217) AND (ll.nUID = 1) AND (epvi.nLangID = 1) GROUP BY `ecpvp`.`nProductVariationID` ORDER BY `epv`.`nOrder` ASC

SELECT

0.173 ms

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 = 1217) 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.104 ms

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.068 ms

SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)

SELECT

0.87 ms

SELECT `ecpog`.`nOptionGroupID`, `eog`.`sName`, `eog`.`sDescription`, `eog`.`nSpecial`, `eog`.`nOrder` FROM `eshop3_conn_product_option_groups` AS `ecpog`
 INNER JOIN `eshop3_option_groups` AS `eog` ON ecpog.nOptionGroupID = eog.nUID AND eog.nPublished = 1 AND eog.nDeleted = 0
 INNER JOIN `eshop3_options` AS `eo` ON eog.nUID = eo.nOptionGroupID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (ecpog.nDeleted = 0) AND (ecpog.nDeleted = 0) AND (ecpog.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) GROUP BY `ecpog`.`nOptionGroupID` ORDER BY `eog`.`nOrder` ASC

SELECT

0.073 ms

SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)

SELECT

0.062 ms

SELECT `ecpog`.`nOptionGroupID`, `eog`.`sName`, `eog`.`sDescription`, `eog`.`nSpecial`, `eog`.`nOrder` FROM `eshop3_conn_product_option_groups` AS `ecpog`
 INNER JOIN `eshop3_option_groups` AS `eog` ON ecpog.nOptionGroupID = eog.nUID AND eog.nPublished = 1 AND eog.nDeleted = 0
 INNER JOIN `eshop3_options` AS `eo` ON eog.nUID = eo.nOptionGroupID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (ecpog.nDeleted = 0) AND (ecpog.nDeleted = 0) AND (ecpog.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) GROUP BY `ecpog`.`nOptionGroupID` ORDER BY `eog`.`nOrder` ASC

SELECT

0.052 ms

SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)

SELECT

0.091 ms

SELECT `eoi`.`sName`, `eoi`.`sUnit`, `eoi`.`sDescription`, `eo`.`nUID`, `eo`.`nOptionGroupID`, `eo`.`sClass`, `eo`.`nOrder` FROM `eshop3_options_i18n` AS `eoi`
 INNER JOIN `eshop3_options` AS `eo` ON eoi.nOptionID = eo.nUID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (eoi.nDeleted = 0) AND (IFNULL(eoi.nLangID, '1') = '1') AND (eoi.nLangID = 1) AND (eo.nOptionGroupID = '1') ORDER BY `eo`.`nOrder` ASC

SELECT

1.845 ms

SELECT `epov`.`nProductID`, `epov`.`nTypeID`, `epov`.`nOptionID`, `epov`.`nPriceID`, `epov`.`sValue`, `epov`.`nDefault`, `epov`.`sFormula`, `ec`.`sLocale`, `ec`.`sSymbol`, `epd`.`nPrice` AS `price`, `eor`.`sExtension`, `eor`.`nOrder`, `eor`.`isCommentEnabled`, `eoi`.`nUID`, `eoi`.`sDescription`, `eoi`.`sValue`, `eoi`.`nOptionRadioID`, `eoi`.`sCommentLabel`, `eoi`.`sDefaultTextLabel`, `eop`.`sName` AS `sProperty` FROM `eshop3_product_options_values` AS `epov`
 INNER JOIN `language_locales` AS `ll` ON ll.nPublished = 1 AND  ll.nDeleted = 0
 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ll.nUID = eccl.nLanguageLocaleID AND eccl.nDeleted = 0
 INNER JOIN `languages` AS `l` ON ll.nLanguageID = l.nUID
 LEFT JOIN `eshop3_currencies` AS `ec` ON eccl.nCurrencyID = ec.nUID
 LEFT JOIN `eshop3_prices_data` AS `epd` ON epd.nPriceID = epov.nPriceID AND epd.nCurrencyID = eccl.nCurrencyID
 INNER JOIN `eshop3_options` AS `eo` ON epov.nTypeID = eo.nUID AND eo.sClass = 'Zfms_Option_Radio' AND eo.nDeleted = 0
 INNER JOIN `eshop3_option_radios` AS `eor` ON eo.nUID = eor.nOptionID AND eor.nPublished = 1 AND eor.nDeleted = 0
 INNER JOIN `eshop3_option_radios_i18n` AS `eoi` ON eor.nUID = eoi.nOptionRadioID AND eoi.nLangID = l.nUID AND eoi.nOptionRadioID IN (epov.nValueID) AND eoi.nDeleted = 0
 LEFT JOIN `eshop3_option_properties` AS `eop` ON eoi.nPropertyID = eop.nUID AND eop.nDeleted = 0 WHERE (epov.nDeleted = 0) AND (eo.nOptionGroupID = '1') AND (epov.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) AND (ll.nUID = 1) ORDER BY `eor`.`nOrder` ASC

SELECT

0.083 ms

SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 3)

SELECT

0.063 ms

SELECT `eoi`.`sName`, `eoi`.`sUnit`, `eoi`.`sDescription`, `eo`.`nUID`, `eo`.`nOptionGroupID`, `eo`.`sClass`, `eo`.`nOrder` FROM `eshop3_options_i18n` AS `eoi`
 INNER JOIN `eshop3_options` AS `eo` ON eoi.nOptionID = eo.nUID AND eo.nPublished = 1 AND eo.nDeleted = 0 WHERE (eoi.nDeleted = 0) AND (IFNULL(eoi.nLangID, '1') = '1') AND (eoi.nLangID = 1) AND (eo.nOptionGroupID = '2') ORDER BY `eo`.`nOrder` ASC

SELECT

1.302 ms

SELECT `epov`.`nProductID`, `epov`.`nTypeID`, `epov`.`nOptionID`, `epov`.`nPriceID`, `epov`.`sValue`, `epov`.`nDefault`, `epov`.`sFormula`, `ec`.`sLocale`, `ec`.`sSymbol`, `epd`.`nPrice` AS `price`, `eoc`.`sExtension`, `eoc`.`nOrder`, `eoc`.`isCommentEnabled`, `eoi`.`nUID`, `eoi`.`sValue`, `eoi`.`nOptionCheckboxID`, `eoi`.`sDescription`, `eoi`.`sCommentLabel`, `eoi`.`sDefaultTextLabel` FROM `eshop3_product_options_values` AS `epov`
 INNER JOIN `language_locales` AS `ll` ON ll.nPublished = 1 AND  ll.nDeleted = 0
 INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ll.nUID = eccl.nLanguageLocaleID AND eccl.nDeleted = 0
 INNER JOIN `languages` AS `l` ON ll.nLanguageID = l.nUID
 LEFT JOIN `eshop3_currencies` AS `ec` ON eccl.nCurrencyID = ec.nUID
 LEFT JOIN `eshop3_prices_data` AS `epd` ON epd.nPriceID = epov.nPriceID AND epd.nCurrencyID = eccl.nCurrencyID
 INNER JOIN `eshop3_options` AS `eo` ON epov.nTypeID = eo.nUID AND eo.sClass = 'Zfms_Option_Checkbox' AND eo.nDeleted = 0
 INNER JOIN `eshop3_option_checkboxes` AS `eoc` ON eo.nUID = eoc.nOptionID AND eoc.nPublished = 1 AND eoc.nDeleted = 0
 INNER JOIN `eshop3_option_checkboxes_i18n` AS `eoi` ON eoc.nUID = eoi.nOptionCheckboxID AND eoi.nLangID = l.nUID AND eoi.nOptionCheckboxID IN (epov.nValueID) AND eoi.nDeleted = 0 WHERE (epov.nDeleted = 0) AND (eo.nOptionGroupID = '2') AND (epov.nProductID = 1217) AND (eo.nUID IN (21, 6, 5, 27)) AND (ll.nUID = 1) ORDER BY `eoc`.`nOrder` ASC

SELECT

0.218 ms

SELECT VERSION()

Общо време

8.759 ms

Executed queries	27
Total time in ms	8.759 ms
Longest query length	1.91 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 = 'blue-natural-stretch-suit') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID)

Executed queries

Total time in ms

8.759 ms

Longest query length

1.91 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 = 'blue-natural-stretch-suit') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID)

Общо време за генериране всички mysql заявки	8.759 ms
Общо време за генериране всичко от кеша	8.038 ms
Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко))	43.933 ms

Общо време за генериране всички mysql заявки

8.759 ms

Общо време за генериране всичко от кеша

8.038 ms

Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко))

43.933 ms

Blue Natural Stretch Suit

PHP съобщения

Информация за кеш-а

Информация за заявките към базата данни

Обобщение