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_low_to_high_2_true_0_array_200 | categoryPageCache | Array | 0.915 ms |
Saved in cache. |
2 | api | api | api_scanmodels | scanModels | Array | 0.703 ms |
Saved in cache. |
3 | eshop3 | eshop3 | eshop3_configs_history_xml | eshop3_configs | Zend_Config_Xml | 0.569 ms |
Loaded from cache. |
4 | eshop3 | eshop3 | eshop3_configs_dragon_routes_xml | eshop3_configs | Zend_Config_Xml | 0.511 ms |
Loaded from cache. |
5 | eshop3 | eshop3 | eshop3_configs_main_ini | eshop3_configs | Zend_Config_Ini | 0.412 ms |
Loaded from cache. |
6 | core | core | all_widgets_connections_65__mode_public__plugin | all_widgets | Array | 0.408 ms |
Loaded from cache. |
7 | core | core | Zfms_Cache_Common | 0.404 ms |
Caching Enabled => Redis - Cache initialized! |
||
8 | core | core | public_acl_objacl | no tag available | Zend_Acl | 0.392 ms |
Loaded from cache. |
9 | core | core | core_configs_bootstrap_xml | core_configs | Zend_Config | 0.351 ms |
Loaded from cache. |
10 | content | content | content_configs_routes_xml | content_configs | Zend_Config | 0.336 ms |
Loaded from cache. |
11 | eshop3 | eshop3 | eshop3_configs_order_mail_xml | eshop3_configs | Zend_Config | 0.314 ms |
Loaded from cache. |
12 | core | core | core_configs_routes_xml | core_configs | Zend_Config | 0.295 ms |
Loaded from cache. |
13 | core | core | getseoplugin_2_1 | getSeoPlugin | Array | 0.249 ms |
Loaded from cache. |
14 | core | core | requestconnections_eshop3_categories_view_0 | RequestConnections | Array | 0.23 ms |
Loaded from cache. |
15 | menus | menus | menus_scanmodels | scanModels | Array | 0.23 ms |
Loaded from cache. |
16 | core | core | core_configs_mail_xml | core_configs | Zend_Config | 0.226 ms |
Loaded from cache. |
17 | eshop3 | eshop3 | eshop3_scanmodels | scanModels | Array | 0.194 ms |
Loaded from cache. |
18 | content | content | content_scanmodels | scanModels | Array | 0.178 ms |
Loaded from cache. |
19 | eshop3 | eshop3 | eshop3_configs_categories_ini | eshop3_configs | Zend_Config_Ini | 0.175 ms |
Loaded from cache. |
20 | api | api | api_scanmodels | scanModels | Array | 0.17 ms |
Loaded from cache. |
21 | core | core | core_configs_site_xml | core_configs | Zend_Config | 0.154 ms |
Loaded from cache. |
22 | core | core | core_scanmodels | scanModels | Array | 0.11 ms |
Loaded from cache. |
22 | Общо | 7.525 ms |
тип на заявка | време (ms) | завършена | заявка |
---|---|---|---|
CONNECT | 0.385 ms | 1 | connect |
QUERY | 0.073 ms | 1 | SET NAMES utf8 |
SELECT | 0.254 ms | 1 | SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'm3h996r1gdhus4r57vsadc9hi9'))) |
SELECT | 0.074 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.163 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.121 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.06 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.071 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 | 352.103 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 = 2 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 = '2')), 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, CASE WHEN eprii_default_variation.nPrice IS NULL THEN eprii.nPrice ELSE eprii_default_variation.nPrice END ASC LIMIT 200 |
SELECT | 0.18 ms | 1 | SELECT VERSION() |
Общо време | 353.656 ms |
Executed queries | 11 |
---|---|
Total time in ms | 353.656 ms |
Longest query length | 352.103 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 = 2 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 = '2')), 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, CASE WHEN eprii_default_variation.nPrice IS NULL THEN eprii.nPrice ELSE eprii_default_variation.nPrice END ASC LIMIT 200 |
Общо време за генериране всички mysql заявки | 353.656 ms |
---|---|
Общо време за генериране всичко от кеша | 7.525 ms |
Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко)) | 375.928 ms |