Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко))
| Тип |
Файл |
Ред |
Съобщение |
| warning |
/home/oliver/oliverwicks/library/Zfms/Controller/Plugin/LanguageLocaleUSD.php |
22 |
Attempt to read property "nLocaleID" on null
|
| warning |
/home/oliver/oliverwicks/application/modules/eshop3/public/views/scripts/products/details.phtml |
734 |
Undefined array key 0
|
| warning |
/home/oliver/oliverwicks/library/Zend/View/Helper/Placeholder/Container/Standalone.php |
132 |
Array to string conversion
|
| warning |
/home/oliver/oliverwicks/library/Zend/View/Helper/Placeholder/Container/Standalone.php |
132 |
Array to string conversion
|
| Номер № |
Модул |
Кеш ИД |
Кеш Таг |
Обект |
Времетраене |
Съобщение |
| 1 |
eshop3 |
eshop3 |
eshop3_configs_dragon_routes_xml |
eshop3_configs |
Zend_Config_Xml |
0.567 ms |
Loaded from cache.
|
| 2 |
core |
core |
|
|
Zfms_Cache_Common |
0.424 ms |
Caching Enabled => Redis - Cache initialized!
|
| 3 |
core |
core |
all_widgets_connections_65__mode_public__plugin |
all_widgets |
Array |
0.412 ms |
Loaded from cache.
|
| 4 |
api |
api |
api_scanmodels |
scanModels |
Array |
0.403 ms |
Saved in cache.
|
| 5 |
eshop3 |
eshop3 |
eshop3_configs_main_ini |
eshop3_configs |
Zend_Config_Ini |
0.318 ms |
Loaded from cache.
|
| 6 |
eshop3 |
eshop3 |
eshop3_configs_history_xml |
eshop3_configs |
Zend_Config_Xml |
0.316 ms |
Loaded from cache.
|
| 7 |
core |
core |
core_configs_bootstrap_xml |
core_configs |
Zend_Config |
0.305 ms |
Loaded from cache.
|
| 8 |
eshop3 |
eshop3 |
eshop3_configs_zo_products_xml |
eshop3_configs |
Zend_Config |
0.301 ms |
Loaded from cache.
|
| 9 |
core |
core |
public_acl_objacl |
no tag available |
Zend_Acl |
0.244 ms |
Loaded from cache.
|
| 10 |
eshop3 |
eshop3 |
eshop3_configs_zo_products_xml |
eshop3_configs |
Zend_Config |
0.214 ms |
Loaded from cache.
|
| 11 |
core |
core |
core_scanmodels |
scanModels |
Array |
0.192 ms |
Loaded from cache.
|
| 12 |
content |
content |
content_configs_routes_xml |
content_configs |
Zend_Config |
0.187 ms |
Loaded from cache.
|
| 13 |
eshop3 |
eshop3 |
eshop3_configs_order_mail_xml |
eshop3_configs |
Zend_Config |
0.185 ms |
Loaded from cache.
|
| 14 |
core |
core |
core_configs_mail_xml |
core_configs |
Zend_Config |
0.18 ms |
Loaded from cache.
|
| 15 |
core |
core |
requestconnections_eshop3_products_details_0 |
RequestConnections |
Array |
0.17 ms |
Loaded from cache.
|
| 16 |
core |
core |
core_configs_routes_xml |
core_configs |
Zend_Config |
0.169 ms |
Loaded from cache.
|
| 17 |
core |
core |
getseoplugin_4_1 |
getSeoPlugin |
Array |
0.155 ms |
Loaded from cache.
|
| 18 |
menus |
menus |
menus_scanmodels |
scanModels |
Array |
0.154 ms |
Loaded from cache.
|
| 19 |
core |
core |
core_configs_site_xml |
core_configs |
Zend_Config |
0.149 ms |
Loaded from cache.
|
| 20 |
content |
content |
content_scanmodels |
scanModels |
Array |
0.133 ms |
Loaded from cache.
|
| 21 |
eshop3 |
eshop3 |
eshop3_scanmodels |
scanModels |
Array |
0.115 ms |
Loaded from cache.
|
| 22 |
api |
api |
api_scanmodels |
scanModels |
Array |
0.105 ms |
Loaded from cache.
|
| 22 |
|
|
|
|
Общо |
5.398 ms |
|
| тип на заявка |
време (ms) |
завършена |
заявка |
| CONNECT |
0.306 ms |
1 |
connect |
| QUERY |
0.062 ms |
1 |
SET NAMES utf8 |
| SELECT |
0.225 ms |
1 |
SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'mvupfop1tri1vb5ed8k1fmcsk3'))) |
| SELECT |
0.079 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.574 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 = 'navy-donegal-herringbone-tweed-blazer') AND (epi.nLangId = 1) LIMIT 1 |
| SELECT |
1.967 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 = 'navy-donegal-herringbone-tweed-blazer') AND (epi.nLangID = '1') AND (ll.nUID = '1') AND (epci.nLangID = ll.nLanguageID) AND (epi.nLangID = ll.nLanguageID) |
| SELECT |
0.442 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 = 1271) |
| SELECT |
0.149 ms |
1 |
SELECT `ypr`.* FROM `yotpo_product_reviews` AS `ypr` WHERE (productId = 1271) LIMIT 1 |
| SELECT |
0.049 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.294 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 = 1271) ORDER BY `nDefault` DESC, `nUID` ASC |
| SELECT |
0.211 ms |
1 |
SELECT `eppi`.* FROM `eshop3_product_phone_images` AS `eppi` WHERE (eppi.nProductID = 1271) ORDER BY `eppi`.`nOrder` ASC |
| SELECT |
0.158 ms |
1 |
SELECT `eppi`.* FROM `eshop3_product_panoramic_images` AS `eppi` WHERE (eppi.nProductID = 1271) ORDER BY `nUID` ASC |
| SELECT |
0.967 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 = 1271) AND (ll.nUID = 1) AND (epvi.nLangID = 1) GROUP BY `ecpvp`.`nProductVariationID` ORDER BY `epv`.`nOrder` ASC |
| SELECT |
0.643 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 = 1271) 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.058 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.045 ms |
1 |
SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 8) |
| SELECT |
0.86 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 = 1271) AND (eo.nUID IN (4, 2, 26, 1, 3, 24, 9, 27)) GROUP BY `ecpog`.`nOptionGroupID` ORDER BY `eog`.`nOrder` ASC |
| SELECT |
0.04 ms |
1 |
SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 8) |
| SELECT |
0.04 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 = 1271) AND (eo.nUID IN (4, 2, 26, 1, 3, 24, 9, 27)) GROUP BY `ecpog`.`nOptionGroupID` ORDER BY `eog`.`nOrder` ASC |
| SELECT |
0.039 ms |
1 |
SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 8) |
| SELECT |
0.055 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 |
2.365 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 = 1271) AND (eo.nUID IN (4, 2, 26, 1, 3, 24, 9, 27)) AND (ll.nUID = 1) ORDER BY `eor`.`nOrder` ASC |
| SELECT |
0.054 ms |
1 |
SELECT `ecpvo`.`nOptionID` FROM `eshop3_conn_product_variations_options` AS `ecpvo` WHERE (ecpvo.nDeleted = 0) AND (nProductVariationID = 8) |
| SELECT |
0.049 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.552 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 = 1271) AND (eo.nUID IN (4, 2, 26, 1, 3, 24, 9, 27)) AND (ll.nUID = 1) ORDER BY `eoc`.`nOrder` ASC |
| SELECT |
0.147 ms |
1 |
SELECT VERSION() |
| Общо време |
11.43 ms |
|
|
| Executed queries |
26 |
| Total time in ms |
11.43 ms |
| Longest query length |
2.365 ms |
| Longest query |
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 = 1271) AND (eo.nUID IN (4, 2, 26, 1, 3, 24, 9, 27)) AND (ll.nUID = 1) ORDER BY `eor`.`nOrder` ASC |
