90s & Extrafine Wool Custom Tailored Suits
No suits match these criteria. Please clear some of the filters!
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.
No suits match these criteria. Please clear some of the filters!
Тип | Файл | Ред | Съобщение |
---|---|---|---|
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/controllers/CategoriesController.php | 555 |
Array to string conversion |
Номер № | Модул | Кеш ИД | Кеш Таг | Обект | Времетраене | Съобщение | |
---|---|---|---|---|---|---|---|
1 | core | core | categorypagecache_189_1_newest_4_true_0_array_200 | categoryPageCache | Array | 0.927 ms |
Saved in cache. |
2 | eshop3 | eshop3 | eshop3_configs_dragon_routes_xml | eshop3_configs | Zend_Config_Xml | 0.491 ms |
Loaded from cache. |
3 | core | core | Zfms_Cache_Common | 0.435 ms |
Caching Enabled => Redis - Cache initialized! |
||
4 | api | api | api_scanmodels | scanModels | Array | 0.43 ms |
Saved in cache. |
5 | core | core | all_widgets_connections_65__mode_public__plugin | all_widgets | Array | 0.42 ms |
Loaded from cache. |
6 | eshop3 | eshop3 | eshop3_configs_history_xml | eshop3_configs | Zend_Config_Xml | 0.345 ms |
Loaded from cache. |
7 | core | core | public_acl_objacl | no tag available | Zend_Acl | 0.326 ms |
Loaded from cache. |
8 | core | core | core_configs_bootstrap_xml | core_configs | Zend_Config | 0.319 ms |
Loaded from cache. |
9 | eshop3 | eshop3 | eshop3_configs_order_mail_xml | eshop3_configs | Zend_Config | 0.306 ms |
Loaded from cache. |
10 | eshop3 | eshop3 | eshop3_configs_main_ini | eshop3_configs | Zend_Config_Ini | 0.279 ms |
Loaded from cache. |
11 | core | core | core_configs_mail_xml | core_configs | Zend_Config | 0.248 ms |
Loaded from cache. |
12 | core | core | requestconnections_eshop3_categories_view_0 | RequestConnections | Array | 0.203 ms |
Loaded from cache. |
13 | content | content | content_configs_routes_xml | content_configs | Zend_Config | 0.193 ms |
Loaded from cache. |
14 | eshop3 | eshop3 | eshop3_configs_categories_ini | eshop3_configs | Zend_Config_Ini | 0.182 ms |
Loaded from cache. |
15 | core | core | core_configs_routes_xml | core_configs | Zend_Config | 0.18 ms |
Loaded from cache. |
16 | core | core | core_configs_site_xml | core_configs | Zend_Config | 0.179 ms |
Loaded from cache. |
17 | core | core | categorypagecache_189_1_newest_4_true_0_array_200 | categoryPageCache | Array | 0.167 ms |
Loaded from cache. |
18 | menus | menus | menus_scanmodels | scanModels | Array | 0.162 ms |
Loaded from cache. |
19 | eshop3 | eshop3 | eshop3_scanmodels | scanModels | Array | 0.142 ms |
Loaded from cache. |
20 | core | core | getseoplugin_2_1 | getSeoPlugin | Array | 0.142 ms |
Loaded from cache. |
21 | core | core | core_scanmodels | scanModels | Array | 0.137 ms |
Loaded from cache. |
22 | api | api | api_scanmodels | scanModels | Array | 0.115 ms |
Loaded from cache. |
23 | content | content | content_scanmodels | scanModels | Array | 0.103 ms |
Loaded from cache. |
23 | Общо | 6.431 ms |
тип на заявка | време (ms) | завършена | заявка |
---|---|---|---|
CONNECT | 0.26 ms | 1 | connect |
QUERY | 0.063 ms | 1 | SET NAMES utf8 |
SELECT | 0.244 ms | 1 | SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = '30q9ji7lso3teeb3s219ene7cc'))) |
SELECT | 0.069 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.128 ms | 1 | SELECT `ec`.*, `eci`.`sName`, `eci`.`sDescription`, `eci`.`sMetaDescription`, `eci`.`sCustomTitle`, `eci`.`sUID`, `l`.`nUID` AS `nLanguageID`, `l`.`sCode` FROM `eshop3_categories` AS `ec` INNER JOIN `eshop3_categories_i18n` AS `eci` ON ec.nUID = eci.nCategoryID AND eci.nDeleted = 0 LEFT JOIN `languages` AS `l` ON eci.nLangID = l.nUID WHERE (ec.nDeleted = 0) AND (ec.nPublished = 1) AND (eci.sUID = 'custom-suits') LIMIT 1 |
SELECT | 0.114 ms | 1 | SELECT `ec`.*, `eci`.`sName`, `eci`.`sDescription`, `eci`.`sMetaDescription`, `eci`.`sCustomTitle`, `eci`.`sUID`, `l`.`nUID` AS `nLanguageID`, `l`.`sCode` FROM `eshop3_categories` AS `ec` INNER JOIN `eshop3_categories_i18n` AS `eci` ON ec.nUID = eci.nCategoryID AND eci.nDeleted = 0 LEFT JOIN `languages` AS `l` ON eci.nLangID = l.nUID WHERE (ec.nDeleted = 0) AND (ec.nPublished = 1) AND (eci.sUID IN ('90s-extrafine-wool-blazers')) |
SELECT | 0.055 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.172 ms | 1 | SELECT `ec`.*, `eci`.`sName`, `eci`.`sCustomTitle`, `eci`.`sUID`, `eci`.`sDescription`, `eci`.`sMetaDescription` FROM `eshop3_categories` AS `ec` INNER JOIN `eshop3_categories_i18n` AS `eci` ON ec.nUID = eci.nCategoryID AND eci.nLangID = 1 AND eci.nDeleted = 0 LEFT JOIN `eshop3_categories` AS `pn` ON ec.nParentID = pn.nUID WHERE (ec.nDeleted = 0) AND (IFNULL(pn.nDeleted, 0) = 0) ORDER BY IFNULL(pn.nOrder, 0), `ec`.`nOrder` ASC |
SELECT | 0.066 ms | 1 | SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.sHrefLink = 'custom-suits') LIMIT 1 |
SELECT | 172.133 ms | 1 | SELECT `ec`.`nUID` AS `nCategoryID`, `eci`.`sName` AS `sCategoryName`, `eci`.`sUID` AS `sCategorySUID`, `ecu`.`sLocale`, `ecu`.`sSymbol`, `ep`.`nTextileID`, `ep`.`sThumbExtension`, `ep`.`sThumbExtensionVersion`, `ep`.`sHoverExtension`, `ep`.`sHoverExtensionVersion`, `ep`.`nInStock`, `ep`.`bIsAvailable`, `ep`.`bIsVotable`, `ep`.`nRequireMeasures`, `ep`.`nProductPartID`, `epi`.`nProductID` AS `nUID`, `epi`.`sName`, `epi`.`sUID`, `eprws`.`nOrder` AS `sRwSubtypeOrder`, `eprwsi`.`sTitle` AS `sRwTitle`, `ed`.`dEndPeriod` AS `dDiscountEnd`, `eprii`.`nPrice`, `eprii_jacket`.`nPrice` AS `nJacketPrice`, `eprii_vest`.`nPrice` AS `nVestPrice`, `eprii_pants`.`nPrice` AS `nPantsPrice`, `ecpvp_default`.`nProductVariationID` AS `nDefaultVariationID`, `epvi_default`.`sName` AS `sVariationName`, `eprii_default_variation`.`nPrice` AS `nDefaultVariationPrice`, `edd_default_variation`.`sFormula` AS `sDiscount`, `et`.`sOriginFlag` AS `sTextileOriginFlag`, `eti`.`sOrigin` AS `sTextileOrigin`, `eps`.`sBackgroundColor` AS `sStatusBackgroundColor`, `epsi`.`sName` AS `sStatusName`, IF(couponDiscountData.sFormula IS NULL, ecpn.sFormula, couponDiscountData.sFormula) AS `sProductCoupon`, `ecpn`.`sCategoryDescription` AS `sCouponDescription`, `ecpn`.`nShowCalculatedPrice` FROM `eshop3_categories` AS `ec` 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 `eshop3_currencies` AS `ecu` ON ecu.nUID = eccl.nCurrencyID AND ecu.nPublished = 1 AND ecu.nDeleted = 0 INNER JOIN `eshop3_categories_i18n` AS `eci` ON ec.nUID = eci.nCategoryID AND eci.nLangID = ll.nLanguageID AND eci.nDeleted = 0 INNER JOIN `eshop3_conn_product_categories` AS `ecpc` ON ecpc.nCategoryID = eci.nCategoryID AND ecpc.nDeleted = 0 INNER JOIN `eshop3_products` AS `ep` ON ep.nUID = ecpc.nProductID AND ep.nPublished = 1 AND ep.nNotListed = 0 INNER JOIN `eshop3_products_i18n` AS `epi` ON epi.nProductID = ep.nUID AND epi.nLangID = ll.nLanguageID AND epi.nDeleted = 0 LEFT JOIN `eshop3_product_rw_subtypes` AS `eprws` ON ep.nRwSubtypeID = eprws.nUID AND epi.nLangID = ll.nLanguageID AND epi.nDeleted = 0 LEFT JOIN `eshop3_product_rw_subtypes_i18n` AS `eprwsi` ON eprwsi.nProductRwSubtypeID = eprws.nUID AND epi.nLangID = ll.nLanguageID AND epi.nDeleted = 0 INNER JOIN `eshop3_conn_product_prices` AS `ecpp` ON ep.nUID = ecpp.nProductID AND ecpp.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 INNER JOIN `eshop3_prices` AS `epri` ON ecpp.nPriceID = epri.nUID AND epri.nDeleted = 0 INNER JOIN `eshop3_prices_data` AS `eprii` ON eprii.nPriceID = epri.nUID AND eprii.nCurrencyID = ecu.nUID 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 `eprii_jacket` ON epri_jacket.nUID = eprii_jacket.nPriceID AND eprii_jacket.nCurrencyID = eprii.nCurrencyID AND eprii_jacket.nDeleted = 0 LEFT JOIN `eshop3_prices` AS `epri_vest` ON ep.nVestPriceID = epri_vest.nUID AND epri_vest.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii_vest` ON epri_vest.nUID = eprii_vest.nPriceID AND eprii_vest.nCurrencyID = eprii.nCurrencyID AND eprii_vest.nDeleted = 0 LEFT JOIN `eshop3_prices` AS `epri_pants` ON ep.nPantsPriceID = epri_pants.nUID AND epri_pants.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii_pants` ON epri_pants.nUID = eprii_pants.nPriceID AND eprii_pants.nCurrencyID = eprii.nCurrencyID AND eprii_pants.nDeleted = 0 LEFT JOIN `eshop3_conn_product_variations_prices` AS `ecpvp_default` ON ecpvp_default.nProductVariationID = 4 AND ecpvp_default.nPriceID IS NOT NULL AND ecpvp_default.nProductID = ep.nUID AND ecpvp_default.nDeleted = 0 LEFT JOIN `eshop3_product_variations_i18n` AS `epvi_default` ON epvi_default.nProductVariationID = ecpvp_default.nProductVariationID LEFT JOIN `eshop3_prices_data` AS `eprii_default_variation` ON eprii_default_variation.nPriceID = ecpvp_default.nPriceID AND eprii_default_variation.nCurrencyID = eprii.nCurrencyID AND eprii_default_variation.nDeleted = 0 LEFT JOIN `eshop3_discounts_data` AS `edd_default_variation` ON edd_default_variation.nDiscountID = ed.nUID AND edd_default_variation.nProductVariationID = ecpvp_default.nProductVariationID AND edd_default_variation.nCurrencyID = ecu.nUID AND edd_default_variation.nDeleted = 0 LEFT JOIN `eshop3_textiles` AS `et` ON ep.nTextileID = et.nUID and et.nDeleted = 0 AND et.nPublished = 1 LEFT JOIN `eshop3_textiles_i18n` AS `eti` ON et.nUID = eti.nTextileID AND eti.nLangID = ll.nLanguageID AND eti.nDeleted = 0 LEFT JOIN `eshop3_product_statuses` AS `eps` ON ep.nStatusFlags = eps.nUID and eps.nPublished = 1 AND eps.nDeleted = 0 LEFT JOIN `eshop3_product_statuses_i18n` AS `epsi` ON eps.nUID = epsi.nProductStatusID AND epsi.nLangID = ll.nLanguageID AND epsi.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.sCategoryDescription IS NOT NULL AND ec2.nSecretSale = 0 WHERE (ecccp2.nProductID = ep.nUID) AND (ecccp2.nDeleted = 0) AND (ec2.nCurrencyID = ecu.nUID) AND (IF ( (SELECT COUNT(*) FROM eshop3_conn_coupon_variations WHERE nCouponID = ecccp2.nCouponID AND nDeleted = 0) > 0 AND ep.nRequireMeasures = 1, (SELECT COUNT(*) FROM `eshop3_conn_coupon_variations` AS `eccv` INNER JOIN `eshop3_conn_product_variations_prices` AS `ecpvp` ON eccv.nVariationID = ecpvp.nProductVariationID AND ecpvp.nDeleted = 0 AND ecpvp.nPriceID IS NOT NULL WHERE (ecpvp.nProductID = ep.nUID) AND (eccv.nCouponID = ecccp2.nCouponID) AND (eccv.nDeleted = 0) AND (eccv.nVariationID = '4')), 1) > 0) ORDER BY `ec2`.`dEndPeriod` DESC LIMIT 1) LEFT JOIN `eshop3_coupons` AS `ecpn` ON ecccp.nCouponID = ecpn.nUID LEFT JOIN `eshop3_discounts` AS `couponDiscount` ON ecpn.nDiscountID = couponDiscount.nUID AND couponDiscount.nPublished = 1 AND couponDiscount.nDeleted = 0 LEFT JOIN `eshop3_discounts_data` AS `couponDiscountData` ON couponDiscount.nUID = couponDiscountData.nDiscountID AND couponDiscountData.nCurrencyID = ecu.nUID AND couponDiscountData.nProductVariationID = ecpvp_default.nProductVariationID AND couponDiscountData.nDeleted = 0 WHERE (ll.nUID = 1) GROUP BY `ep`.`nUID` HAVING (COUNT(CASE WHEN ec.nUID IN ('189') THEN 1 END) > 0) ORDER BY `ep`.`bIsOutOfStock` ASC, `ep`.`bIsAvailable` DESC, ep.nStatusFlags = 1 DESC, ep.dCreated DESC LIMIT 200 |
SELECT | 0.243 ms | 1 | SELECT VERSION() |
Общо време | 173.547 ms |
Executed queries | 11 |
---|---|
Total time in ms | 173.547 ms |
Longest query length | 172.133 ms |
Longest query | SELECT `ec`.`nUID` AS `nCategoryID`, `eci`.`sName` AS `sCategoryName`, `eci`.`sUID` AS `sCategorySUID`, `ecu`.`sLocale`, `ecu`.`sSymbol`, `ep`.`nTextileID`, `ep`.`sThumbExtension`, `ep`.`sThumbExtensionVersion`, `ep`.`sHoverExtension`, `ep`.`sHoverExtensionVersion`, `ep`.`nInStock`, `ep`.`bIsAvailable`, `ep`.`bIsVotable`, `ep`.`nRequireMeasures`, `ep`.`nProductPartID`, `epi`.`nProductID` AS `nUID`, `epi`.`sName`, `epi`.`sUID`, `eprws`.`nOrder` AS `sRwSubtypeOrder`, `eprwsi`.`sTitle` AS `sRwTitle`, `ed`.`dEndPeriod` AS `dDiscountEnd`, `eprii`.`nPrice`, `eprii_jacket`.`nPrice` AS `nJacketPrice`, `eprii_vest`.`nPrice` AS `nVestPrice`, `eprii_pants`.`nPrice` AS `nPantsPrice`, `ecpvp_default`.`nProductVariationID` AS `nDefaultVariationID`, `epvi_default`.`sName` AS `sVariationName`, `eprii_default_variation`.`nPrice` AS `nDefaultVariationPrice`, `edd_default_variation`.`sFormula` AS `sDiscount`, `et`.`sOriginFlag` AS `sTextileOriginFlag`, `eti`.`sOrigin` AS `sTextileOrigin`, `eps`.`sBackgroundColor` AS `sStatusBackgroundColor`, `epsi`.`sName` AS `sStatusName`, IF(couponDiscountData.sFormula IS NULL, ecpn.sFormula, couponDiscountData.sFormula) AS `sProductCoupon`, `ecpn`.`sCategoryDescription` AS `sCouponDescription`, `ecpn`.`nShowCalculatedPrice` FROM `eshop3_categories` AS `ec` 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 `eshop3_currencies` AS `ecu` ON ecu.nUID = eccl.nCurrencyID AND ecu.nPublished = 1 AND ecu.nDeleted = 0 INNER JOIN `eshop3_categories_i18n` AS `eci` ON ec.nUID = eci.nCategoryID AND eci.nLangID = ll.nLanguageID AND eci.nDeleted = 0 INNER JOIN `eshop3_conn_product_categories` AS `ecpc` ON ecpc.nCategoryID = eci.nCategoryID AND ecpc.nDeleted = 0 INNER JOIN `eshop3_products` AS `ep` ON ep.nUID = ecpc.nProductID AND ep.nPublished = 1 AND ep.nNotListed = 0 INNER JOIN `eshop3_products_i18n` AS `epi` ON epi.nProductID = ep.nUID AND epi.nLangID = ll.nLanguageID AND epi.nDeleted = 0 LEFT JOIN `eshop3_product_rw_subtypes` AS `eprws` ON ep.nRwSubtypeID = eprws.nUID AND epi.nLangID = ll.nLanguageID AND epi.nDeleted = 0 LEFT JOIN `eshop3_product_rw_subtypes_i18n` AS `eprwsi` ON eprwsi.nProductRwSubtypeID = eprws.nUID AND epi.nLangID = ll.nLanguageID AND epi.nDeleted = 0 INNER JOIN `eshop3_conn_product_prices` AS `ecpp` ON ep.nUID = ecpp.nProductID AND ecpp.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 INNER JOIN `eshop3_prices` AS `epri` ON ecpp.nPriceID = epri.nUID AND epri.nDeleted = 0 INNER JOIN `eshop3_prices_data` AS `eprii` ON eprii.nPriceID = epri.nUID AND eprii.nCurrencyID = ecu.nUID 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 `eprii_jacket` ON epri_jacket.nUID = eprii_jacket.nPriceID AND eprii_jacket.nCurrencyID = eprii.nCurrencyID AND eprii_jacket.nDeleted = 0 LEFT JOIN `eshop3_prices` AS `epri_vest` ON ep.nVestPriceID = epri_vest.nUID AND epri_vest.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii_vest` ON epri_vest.nUID = eprii_vest.nPriceID AND eprii_vest.nCurrencyID = eprii.nCurrencyID AND eprii_vest.nDeleted = 0 LEFT JOIN `eshop3_prices` AS `epri_pants` ON ep.nPantsPriceID = epri_pants.nUID AND epri_pants.nDeleted = 0 LEFT JOIN `eshop3_prices_data` AS `eprii_pants` ON epri_pants.nUID = eprii_pants.nPriceID AND eprii_pants.nCurrencyID = eprii.nCurrencyID AND eprii_pants.nDeleted = 0 LEFT JOIN `eshop3_conn_product_variations_prices` AS `ecpvp_default` ON ecpvp_default.nProductVariationID = 4 AND ecpvp_default.nPriceID IS NOT NULL AND ecpvp_default.nProductID = ep.nUID AND ecpvp_default.nDeleted = 0 LEFT JOIN `eshop3_product_variations_i18n` AS `epvi_default` ON epvi_default.nProductVariationID = ecpvp_default.nProductVariationID LEFT JOIN `eshop3_prices_data` AS `eprii_default_variation` ON eprii_default_variation.nPriceID = ecpvp_default.nPriceID AND eprii_default_variation.nCurrencyID = eprii.nCurrencyID AND eprii_default_variation.nDeleted = 0 LEFT JOIN `eshop3_discounts_data` AS `edd_default_variation` ON edd_default_variation.nDiscountID = ed.nUID AND edd_default_variation.nProductVariationID = ecpvp_default.nProductVariationID AND edd_default_variation.nCurrencyID = ecu.nUID AND edd_default_variation.nDeleted = 0 LEFT JOIN `eshop3_textiles` AS `et` ON ep.nTextileID = et.nUID and et.nDeleted = 0 AND et.nPublished = 1 LEFT JOIN `eshop3_textiles_i18n` AS `eti` ON et.nUID = eti.nTextileID AND eti.nLangID = ll.nLanguageID AND eti.nDeleted = 0 LEFT JOIN `eshop3_product_statuses` AS `eps` ON ep.nStatusFlags = eps.nUID and eps.nPublished = 1 AND eps.nDeleted = 0 LEFT JOIN `eshop3_product_statuses_i18n` AS `epsi` ON eps.nUID = epsi.nProductStatusID AND epsi.nLangID = ll.nLanguageID AND epsi.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.sCategoryDescription IS NOT NULL AND ec2.nSecretSale = 0 WHERE (ecccp2.nProductID = ep.nUID) AND (ecccp2.nDeleted = 0) AND (ec2.nCurrencyID = ecu.nUID) AND (IF ( (SELECT COUNT(*) FROM eshop3_conn_coupon_variations WHERE nCouponID = ecccp2.nCouponID AND nDeleted = 0) > 0 AND ep.nRequireMeasures = 1, (SELECT COUNT(*) FROM `eshop3_conn_coupon_variations` AS `eccv` INNER JOIN `eshop3_conn_product_variations_prices` AS `ecpvp` ON eccv.nVariationID = ecpvp.nProductVariationID AND ecpvp.nDeleted = 0 AND ecpvp.nPriceID IS NOT NULL WHERE (ecpvp.nProductID = ep.nUID) AND (eccv.nCouponID = ecccp2.nCouponID) AND (eccv.nDeleted = 0) AND (eccv.nVariationID = '4')), 1) > 0) ORDER BY `ec2`.`dEndPeriod` DESC LIMIT 1) LEFT JOIN `eshop3_coupons` AS `ecpn` ON ecccp.nCouponID = ecpn.nUID LEFT JOIN `eshop3_discounts` AS `couponDiscount` ON ecpn.nDiscountID = couponDiscount.nUID AND couponDiscount.nPublished = 1 AND couponDiscount.nDeleted = 0 LEFT JOIN `eshop3_discounts_data` AS `couponDiscountData` ON couponDiscount.nUID = couponDiscountData.nDiscountID AND couponDiscountData.nCurrencyID = ecu.nUID AND couponDiscountData.nProductVariationID = ecpvp_default.nProductVariationID AND couponDiscountData.nDeleted = 0 WHERE (ll.nUID = 1) GROUP BY `ep`.`nUID` HAVING (COUNT(CASE WHEN ec.nUID IN ('189') THEN 1 END) > 0) ORDER BY `ep`.`bIsOutOfStock` ASC, `ep`.`bIsAvailable` DESC, ep.nStatusFlags = 1 DESC, ep.dCreated DESC LIMIT 200 |
Общо време за генериране всички mysql заявки | 173.547 ms |
---|---|
Общо време за генериране всичко от кеша | 6.431 ms |
Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко)) | 194.565 ms |