Navy & Blue Custom Tailored Suits
Navy & Blue
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.
Navy & Blue
Тип | Файл | Ред | Съобщение |
---|---|---|---|
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_185_1_low_to_high_4_true_0_array_200 | categoryPageCache | Array | 0.992 ms |
Saved in cache. |
2 | eshop3 | eshop3 | eshop3_configs_dragon_routes_xml | eshop3_configs | Zend_Config_Xml | 0.504 ms |
Loaded from cache. |
3 | core | core | Zfms_Cache_Common | 0.477 ms |
Caching Enabled => Redis - Cache initialized! |
||
4 | core | core | all_widgets_connections_65__mode_public__plugin | all_widgets | Array | 0.469 ms |
Loaded from cache. |
5 | api | api | api_scanmodels | scanModels | Array | 0.413 ms |
Saved in cache. |
6 | core | core | core_configs_bootstrap_xml | core_configs | Zend_Config | 0.385 ms |
Loaded from cache. |
7 | eshop3 | eshop3 | eshop3_configs_main_ini | eshop3_configs | Zend_Config_Ini | 0.384 ms |
Loaded from cache. |
8 | core | core | public_acl_objacl | no tag available | Zend_Acl | 0.336 ms |
Loaded from cache. |
9 | eshop3 | eshop3 | eshop3_scanmodels | scanModels | Array | 0.318 ms |
Loaded from cache. |
10 | eshop3 | eshop3 | eshop3_configs_history_xml | eshop3_configs | Zend_Config_Xml | 0.294 ms |
Loaded from cache. |
11 | core | core | core_configs_routes_xml | core_configs | Zend_Config | 0.277 ms |
Loaded from cache. |
12 | eshop3 | eshop3 | eshop3_configs_order_mail_xml | eshop3_configs | Zend_Config | 0.262 ms |
Loaded from cache. |
13 | core | core | core_configs_mail_xml | core_configs | Zend_Config | 0.255 ms |
Loaded from cache. |
14 | core | core | requestconnections_eshop3_categories_view_0 | RequestConnections | Array | 0.208 ms |
Loaded from cache. |
15 | eshop3 | eshop3 | eshop3_configs_categories_ini | eshop3_configs | Zend_Config_Ini | 0.201 ms |
Loaded from cache. |
16 | content | content | content_configs_routes_xml | content_configs | Zend_Config | 0.191 ms |
Loaded from cache. |
17 | api | api | api_scanmodels | scanModels | Array | 0.182 ms |
Loaded from cache. |
18 | core | core | core_configs_site_xml | core_configs | Zend_Config | 0.174 ms |
Loaded from cache. |
19 | core | core | getseoplugin_2_1 | getSeoPlugin | Array | 0.142 ms |
Loaded from cache. |
20 | menus | menus | menus_scanmodels | scanModels | Array | 0.139 ms |
Loaded from cache. |
21 | content | content | content_scanmodels | scanModels | Array | 0.136 ms |
Loaded from cache. |
22 | core | core | core_scanmodels | scanModels | Array | 0.112 ms |
Loaded from cache. |
22 | Общо | 6.851 ms |
тип на заявка | време (ms) | завършена | заявка |
---|---|---|---|
CONNECT | 0.34 ms | 1 | connect |
QUERY | 0.072 ms | 1 | SET NAMES utf8 |
SELECT | 0.267 ms | 1 | SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'jm4fbm28qhg3fra86d8e8n49aj'))) |
SELECT | 0.089 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.198 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.087 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 ('navy-blue-blazers')) |
SELECT | 0.064 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.227 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.078 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 | 189.411 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 ('185') 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.208 ms | 1 | SELECT VERSION() |
Общо време | 191.041 ms |
Executed queries | 11 |
---|---|
Total time in ms | 191.041 ms |
Longest query length | 189.411 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 ('185') 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 заявки | 191.041 ms |
---|---|
Общо време за генериране всичко от кеша | 6.851 ms |
Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко)) | 212.367 ms |