debugQuery(): [1] SELECT * FROM RedirectUrls WHERE RedirectUrlFrom = "/%D1%84%D0%B5%D0%BD%D0%B5%D1%80%D0%B8/varta.html?page=1" LIMIT 1
[0.000597 of 0.000597 / 1]


scCustomUrlResolver->resolve()    custom_url.php[12]
miStaticDBUtil::execSelect()    custom_url.php[22]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [2] SELECT * FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlHash="4187264720"
[0.000778 of 0.001375 / 2]


scCustomUrlResolver->resolve()    custom_url.php[12]
scUrlResolver->resolve()    custom_url.php[34]
scUrlResolver->resolveCustomUrl()    UrlResolver.php[589]
scUrlResolver->getBestMatch()    UrlResolver.php[665]
miStaticDBUtil::execSelect()    UrlResolver.php[705]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [3] SELECT LanguageID,CategoryName FROM CategoriesML WHERE CategoryID="78"
[0.000626 of 0.002001 / 3]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scCategorySeo->__construct()    categories.php[202]
scDynamicPageSeo->__construct()    Seo.php[473]
scSeo->initCanonicalUrlTag()    Seo.php[377]
scSeo->prepareCanonicalUrl()    Seo.php[234]
scFriendlyUrl::get()    Seo.php[303]
scBaseUrlResolver->getName()    FriendlyUrl.php[78]
scBaseUrlResolver->getNames()    UrlResolver.php[65]
miSqlRecordset->getAllRecords()    UrlResolver.php[56]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[275]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [4] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 1 AND CustomUrlEntityID IN (78)
[0.000571 of 0.002572 / 4]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scCategorySeo->__construct()    categories.php[202]
scDynamicPageSeo->__construct()    Seo.php[473]
scSeo->initCanonicalUrlTag()    Seo.php[377]
scSeo->prepareCanonicalUrl()    Seo.php[234]
scFriendlyUrl::get()    Seo.php[303]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[80]
scCustomUrls::getPrimaryUrl()    FriendlyUrl.php[90]
miStaticDBUtil::execSelect()    CustomUrls.php[44]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [5] SELECT CMSLayoutID FROM CMSLayoutsXPages WHERE SkinID="105" AND CategoryID="78"
[0.000411 of 0.002983 / 5]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scCategoryLayout->__construct()    categories.php[203]
scDynamicPageLayout->__construct()    Layout.php[136]
scLayout->__construct()    Layout.php[70]
scCategoryLayout->getLayoutId()    Layout.php[13]
scLayoutUtil::getPageLayout()    Layout.php[142]
scDal->getLayoutIdForPage()    LayoutUtil.php[437]
miStaticDBUtil::execSelect()    Dal.php[129]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [6] SELECT *, Categories.CategoryID as CategoryID, IFNULL(CategoryBoxEnd, "") AS HTML_CategoryBoxEnd, IFNULL(CategoryDescription, "") AS HTML_CategoryDescription FROM Categories LEFT JOIN CategoriesML ON Categories.CategoryID=CategoriesML.CategoryID AND LanguageID="2" WHERE Categories.CategoryID="78"
[0.000729 of 0.003712 / 6]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scCategoryProductListing->applySearchCriteria()    ProductListing.php[50]
scCategoryProductListing->getCategoryRow()    categories.php[35]
scCategories::getCategoryRow()    categories.php[184]
miStaticDBUtil::execSelect()    Categories.php[69]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [7] SELECT B.CategoryID FROM Categories A JOIN Categories B WHERE A.CategoryID=78 AND A.CategoryLeft <= B.CategoryLeft AND A.CategoryRight >= B.CategoryRight ORDER BY B.CategoryLeft
[0.000928 of 0.00464 / 7]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scUserSearch->getRecords()    ProductListing.php[53]
scUserSearch->getFindersSubquery()    UserSearch.php[827]
scUserSearchFinder->getFindQuery()    UserSearch.php[854]
scUserSearchFinder->modifyRecordset()    UserSearch.php[28]
scRecordsetModifierCategory->modifyRecordset()    UserSearch.php[52]
scRecordsetModifierCategory->addCategoryBranchFilter()    UserSearch.php[531]
scCategories::getFullBranchFromCategory()    UserSearch.php[540]
miUtil::getDBArray()    Categories.php[59]
miStaticDBUtil::execSelect()    Util.php[14]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [8] SELECT ResultFinder, ResultID, ProductID FROM ((SELECT "scUserSearchProductsFinder" AS ResultFinder,SearchProducts.ProductID AS ResultID,SearchProducts.ProductID AS ProductID,SearchProducts.ProductCreatedTimestamp AS ProductCreatedTimestamp FROM ProductVariants RIGHT JOIN Products AS SearchProducts USING(ProductID) INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive IN ("1","3") AND SearchProducts.ProductIsVariant="0" AND ProductVariants.ProductVariantID IS NULL AND ProductXCategories.CategoryID IN(78,250,251,252) GROUP BY ProductID) UNION (SELECT "scUserSearchProductVariantsFinder" AS ResultFinder,(CASE WHEN (SELECT ProductVariantID FROM ProductVariants WHERE ProductVariantCode = "" AND ProductVariantCode <> "") IS NULL THEN GROUP_CONCAT(DISTINCT ProductVariants.ProductVariantID ORDER BY ProductVariantIsDefault DESC) ELSE (SELECT DISTINCT ProductVariantID FROM ProductVariants WHERE ProductVariantCode = "" AND ProductVariantCode <> "") END ) AS ResultID,ProductVariants.ProductID AS ProductID,SearchProducts.ProductCreatedTimestamp AS ProductCreatedTimestamp FROM ProductVariants INNER JOIN Products AS SearchProducts USING(ProductID) INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive IN ("1","3") AND ProductXCategories.CategoryID IN(78,250,251,252) GROUP BY ProductID)) AS Products GROUP BY ProductID ORDER BY ProductCreatedTimestamp DESC, ProductID DESC LIMIT 0, 32
[0.004118 of 0.008758 / 8]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scUserSearch->getRecords()    ProductListing.php[53]
miStaticDBUtil::execSelect()    UserSearch.php[828]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [9] SELECT ProductImages.ProductImageID,ProductsML.ProductName,ProductsML.ProductDescription,NULL AS ProductVariantID,NULL AS ProductVariantCode,NULL AS ProductVariantPrice,NULL AS ProductVariantBonusPointsPrice,NULL AS ProductVariantWeight,NULL AS ProductVariantQuantity,NULL AS ProductVariantAvailabilityStatus,NULL AS AvailabilityLabelID,NULL AS ProductVariantIsDefault,Products.ProductCreatedTimestamp AS ProductCreatedTimestamp,Products.ProductOrdersCount AS ProductOrdersCount,Products.*,ProductImages.ProductImage AS ProductImage,ProductImages.ProductImageWidth AS ProductImageWidth,ProductImages.ProductImageHeight AS ProductImageHeight,ProductImages.ProductImageSize AS ProductImageSize,ProductImages.ProductImageCdn AS ProductImageCdn,ProductImages.ProductImageThumb AS ProductImageThumb,ProductImages.ProductImageThumbWidth AS ProductImageThumbWidth,ProductImages.ProductImageThumbHeight AS ProductImageThumbHeight,ProductImages.ProductImageThumbSize AS ProductImageThumbSize,ProductImages.ProductImageThumbCdn AS ProductImageThumbCdn,ProductImagesML.ProductImageAlt,NULL AS ProductVariantImage,NULL AS ProductVariantImageWidth,NULL AS ProductVariantImageHeight,NULL AS ProductVariantImageSize,NULL AS ProductVariantImageCdn,NULL AS ProductVariantImageThumb,NULL AS ProductVariantImageThumbWidth,NULL AS ProductVariantImageThumbHeight,NULL AS ProductVariantImageThumbSize,NULL AS ProductVariantImageThumbCdn,NULL AS ProductImageAlt FROM Products LEFT JOIN ProductsML ON Products.ProductID = ProductsML.ProductID AND ProductsML.LanguageID = 2 LEFT JOIN ProductImages ON ProductImages.ProductID = Products.ProductID AND ProductImageIsDefault LEFT JOIN ProductImagesML ON ProductImages.ProductImageID = ProductImagesML.ProductImageID AND ProductImagesML.LanguageID = 2 WHERE Products.ProductID IN ("5111","2444","2443","2410","2409","2406","2405","2401","2398","5875","5729","5728","5727","5724","5722","5530","4692","2442","2440","2439","2438","2436","2435","2433","2432","2428","2425","2422","2397","4768","4740","4738") AND Products.ProductIsVariant="0" GROUP BY Products.ProductID
[0.003532 of 0.01229 / 9]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scUserSearch->getRecords()    ProductListing.php[53]
scUserSearchProductsFinder->getResultData()    UserSearch.php[836]
miSqlRecordset->getAllRecords()    UserSearch.php[83]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[275]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [10] SELECT *, Products.ProductID as ProductID, FeaturedProductSort as ProductIDSort FROM FeaturedProductCategories INNER JOIN FeaturedProducts USING(FeaturedProductID) INNER JOIN Products USING(ProductID) LEFT JOIN ProductsML USING(ProductID) LEFT JOIN ProductImages ON(Products.ProductDefaultImageID = ProductImages.ProductImageID) LEFT JOIN ProductImagesML ON(ProductImages.ProductImageID = ProductImagesML.ProductImageID AND ProductImagesML.LanguageID = "2") WHERE ProductsML.LanguageID = "2" AND FeaturedProductCategories.CategoryID = "78" AND ProductIsActive IN ("1","3") ORDER BY ProductCreatedTimestamp DESC
[0.00135 of 0.01364 / 10]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scCategoryProductListing->getFeaturedProducts()    categories.php[27]
miStaticDBUtil::execSelect()    categories.php[178]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [11] SELECT COUNT(DISTINCT ProductID) AS Count FROM ((SELECT "scUserSearchProductsFinder" AS ResultFinder,SearchProducts.ProductID AS ResultID,SearchProducts.ProductID AS ProductID,SearchProducts.ProductCreatedTimestamp AS ProductCreatedTimestamp FROM ProductVariants RIGHT JOIN Products AS SearchProducts USING(ProductID) INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive IN ("1","3") AND SearchProducts.ProductIsVariant="0" AND ProductVariants.ProductVariantID IS NULL AND ProductXCategories.CategoryID IN(78,250,251,252) GROUP BY ProductID) UNION (SELECT "scUserSearchProductVariantsFinder" AS ResultFinder,(CASE WHEN (SELECT ProductVariantID FROM ProductVariants WHERE ProductVariantCode = "" AND ProductVariantCode <> "") IS NULL THEN GROUP_CONCAT(DISTINCT ProductVariants.ProductVariantID ORDER BY ProductVariantIsDefault DESC) ELSE (SELECT DISTINCT ProductVariantID FROM ProductVariants WHERE ProductVariantCode = "" AND ProductVariantCode <> "") END ) AS ResultID,ProductVariants.ProductID AS ProductID,SearchProducts.ProductCreatedTimestamp AS ProductCreatedTimestamp FROM ProductVariants INNER JOIN Products AS SearchProducts USING(ProductID) INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive IN ("1","3") AND ProductXCategories.CategoryID IN(78,250,251,252) GROUP BY ProductID)) AS Products
[0.002864 of 0.016504 / 11]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scUserSearch->getRecordsCount()    categories.php[58]
miStaticDBUtil::execSelect()    UserSearch.php[819]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [12] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 2 AND CustomUrlEntityID IN (5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738)
[0.001646 of 0.01815 / 12]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductSL->getUrl()    ProductListingService.php[56]
scFriendlyUrl::get()    ProductSL.php[65]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[80]
scCustomUrls::getPrimaryUrl()    FriendlyUrl.php[90]
miStaticDBUtil::execSelect()    CustomUrls.php[44]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [13] SELECT BrandID,BrandName,BrandImage,BrandImageWidth,BrandImageHeight,BrandHasInfoLink,CMSRichTextPageID,BrandInfoLinkTitle FROM Brands INNER JOIN BrandsML USING(BrandID) WHERE LanguageID="2" AND BrandID IN (SELECT BrandID FROM Products WHERE ProductID IN (5111,2444,2443,2410,2409,2406,2405,2401,2398,5875,5729,5728,5727,5724,5722,5530,4692,2442,2440,2439,2438,2436,2435,2433,2432,2428,2425,2422,2397,4768,4740,4738,5111,2444,2443,2410,2409,2406,2405,2401,2398,5875,5729,5728,5727,5724,5722,5530,4692,2442,2440,2439,2438,2436,2435,2433,2432,2428,2425,2422,2397,4768,4740,4738))
[0.001646 of 0.019796 / 13]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductSL->getBrand()    ProductListingService.php[67]
scProductDomainObject->getBrand()    ProductSL.php[308]
scDal->getBrandData()    ProductDomainObject.php[418]
scDal->loadProductBrandsIntoCache()    Dal.php[379]
miSqlRecordset->getAllRecords()    Dal.php[415]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[275]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [14] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 6 AND CustomUrlEntityID IN (5)
(simil: 2)
[0.000572 of 0.020368 / 14]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scBrandDomainObject->getUrl()    ProductListingService.php[73]
scFriendlyUrl::get()    BrandDomainObject.php[69]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[80]
scCustomUrls::getPrimaryUrl()    FriendlyUrl.php[90]
miStaticDBUtil::execSelect()    CustomUrls.php[44]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [15] SELECT DISTINCT AvailabilityLabelID, AvailabilityLabelShort FROM AvailabilityLabelsML LEFT JOIN Products USING(AvailabilityLabelID) WHERE (AvailabilityLabelsML.AvailabilityLabelID IN(3,2) OR ProductID IN (5676,5675,5674,46,228,230,385,6127,5447,5961,5111,2444,2443,2410,2409,2406,2405,2401,2398,5875,5729,5728,5727,5724,5722,5530,4692,2442,2440,2439,2438,2436,2435,2433,2432,2428,2425,2422,2397,4768,4740,4738,5111,2444,2443,2410,2409,2406,2405,2401,2398,5875,5729,5728,5727,5724,5722,5530,4692,2442,2440,2439,2438,2436,2435,2433,2432,2428,2425,2422,2397,4768,4740,4738)) AND LanguageID = 2
[0.000843 of 0.021211 / 15]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getListingItemLabelHtml()    ProductListingService.php[79]
scDal->getAvailabilityLabelShort()    ProductListingService.php[255]
scDal->loadProductAvailabilityStatuses()    Dal.php[859]
miUtil::getDBArray()    Dal.php[871]
miStaticDBUtil::execSelect()    Util.php[14]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [16] SELECT * FROM OptionGroups LEFT JOIN OptionGroupsML ON (OptionGroups.OptionGroupID = OptionGroupsML.OptionGroupID AND OptionGroupsML.LanguageID = "2") LEFT JOIN Options ON (OptionGroups.OptionGroupID = Options.OptionGroupID) LEFT JOIN OptionsML ON (Options.OptionID = OptionsML.OptionID AND OptionsML.LanguageID = "2") LEFT JOIN ProductOptions ON (ProductOptions.OptionID = Options.OptionID) WHERE ProductOptions.ProductID IN (5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738) ORDER BY OptionGroupSort, OptionSort
[0.001578 of 0.022789 / 16]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceModifications()    ProductListingService.php[301]
scProductPrice::getPriceModifications()    ProductListingService.php[872]
scProductPriceDiscount->getPriceModifications()    ProductPrice.php[94]
scProductService::getProductsOptions()    discount.php[70]
miStaticDBUtil::execSelect()    ProductService.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [17] SELECT * FROM LocalOptionGroups LEFT JOIN LocalOptionGroupsML ON (LocalOptionGroups.LocalOptionGroupID = LocalOptionGroupsML.LocalOptionGroupID AND LocalOptionGroupsML.LanguageID = "2") LEFT JOIN LocalOptions ON (LocalOptionGroups.LocalOptionGroupID = LocalOptions.LocalOptionGroupID) LEFT JOIN LocalOptionsML ON (LocalOptions.LocalOptionID = LocalOptionsML.LocalOptionID AND LocalOptionsML.LanguageID = "2") WHERE ProductID IN (5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738) ORDER BY LocalOptionGroupSort,LocalOptionSort
[0.001329 of 0.024118 / 17]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceModifications()    ProductListingService.php[301]
scProductPrice::getPriceModifications()    ProductListingService.php[872]
scProductPriceDiscount->getPriceModifications()    ProductPrice.php[94]
scProductService::getProductsOptions()    discount.php[70]
miStaticDBUtil::execSelect()    ProductService.php[286]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [18] (SELECT ProductID, CategoryID FROM Products WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738))UNION ALL (SELECT ProductID, CategoryID FROM ProductXCategories WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738))
[0.002023 of 0.026141 / 18]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceModifications()    ProductListingService.php[301]
scProductPrice::getPriceModifications()    ProductListingService.php[872]
scProductPriceDiscount->getPriceModifications()    ProductPrice.php[94]
scDiscountCalculator->getProductDiscount()    discount.php[74]
scDiscountCalculator->getCachedListingItemData()    DiscountCalculator.php[39]
scProductSL->getAllCategoryIds()    DiscountCalculator.php[151]
scDal->getProductCategories()    ProductSL.php[73]
scDal->loadProductsCategories()    Dal.php[397]
miStaticDBUtil::execSelect()    Dal.php[735]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [19] SET group_concat_max_len = 1000000
[0.000296 of 0.026437 / 19]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceModifications()    ProductListingService.php[301]
scProductPrice::getPriceModifications()    ProductListingService.php[872]
scProductPriceDiscount->getPriceModifications()    ProductPrice.php[94]
scDiscountCalculator->getProductDiscount()    discount.php[74]
scDiscountsContainer->getDiscounts()    DiscountCalculator.php[40]
scDiscountsContainer->initDiscounts()    DiscountsContainer.php[49]
miStaticDBUtil::execSQL()    DiscountsContainer.php[59]
miDBUtilImpl->execSQL()    StaticDBUtil.php[28]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [20] SELECT Discounts.DiscountID as DiscountID, DiscountType, DiscountValue, DiscountFreeShippingMethodID, DiscountApplyMode, PaymentModuleID, DiscountFirstOrderOnly, (SELECT GROUP_CONCAT(ProductID) FROM DiscountProducts WHERE DiscountProducts.DiscountID=Discounts.DiscountID) AS DiscountProductIds, (SELECT GROUP_CONCAT(CategoryID) FROM DiscountCategories WHERE DiscountCategories.DiscountID=Discounts.DiscountID) AS DiscountCategoryIds, (SELECT GROUP_CONCAT(BrandID) FROM DiscountBrands WHERE DiscountBrands.DiscountID=Discounts.DiscountID) AS DiscountBrandIds, (SELECT GROUP_CONCAT(OptionID) FROM DiscountOptions WHERE DiscountOptions.DiscountID=Discounts.DiscountID) AS DiscountOptionIds, (SELECT GROUP_CONCAT(CustomerID) FROM DiscountCustomers WHERE DiscountCustomers.DiscountID=Discounts.DiscountID) AS DiscountCustomerIds, (SELECT GROUP_CONCAT(CustomerGroupID) FROM DiscountCustomerGroups WHERE DiscountCustomerGroups.DiscountID=Discounts.DiscountID) AS DiscountCustomerGroupIds, (SELECT GROUP_CONCAT(DiscountCombinedDiscountID) FROM DiscountCombinedDiscounts WHERE DiscountCombinedDiscounts.DiscountID=Discounts.DiscountID) AS DiscountCombinedDiscountIds, DiscountConditionBuyAProductFrom, DiscountConditionBuyXProductsFrom, DiscountConditionBuyProductAPlusB, DiscountIsPromotion, DiscountConditionOrderExceeds, DiscountConditionOrderTotalItemsQuantityExceeds, DiscountConditionProductQuantityExceeds, DiscountConditionProductSpendExceeds, DiscountBenefitFreeProducts, DiscountFreeProductIds, DiscountFreeCategoryIds, DiscountFreeBrandIds, DiscountBenefitDiscountOtherProducts, DiscountApplyToProductIds, DiscountApplyToCategoryIds, DiscountApplyToBrandIds, DiscountConditionProduct2Ids, DiscountConditionCategory2Ids, DiscountConditionBrand2Ids, DiscountBenefitFreeShipping, DiscountPromotionPageManualDescription, DiscountSort FROM Discounts WHERE DiscountIsActive = 1 AND DiscountValidFrom <= "2025-04-28 14:31" AND DiscountValidTo >= "2025-04-28 14:31" ORDER BY DiscountSort ASC
[0.00195 of 0.028387 / 20]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceModifications()    ProductListingService.php[301]
scProductPrice::getPriceModifications()    ProductListingService.php[872]
scProductPriceDiscount->getPriceModifications()    ProductPrice.php[94]
scDiscountCalculator->getProductDiscount()    discount.php[74]
scDiscountsContainer->getDiscounts()    DiscountCalculator.php[40]
scDiscountsContainer->initDiscounts()    DiscountsContainer.php[49]
miStaticDBUtil::execSelect()    DiscountsContainer.php[68]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [21] SELECT ProductID FROM ProductOptionGroups WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738) UNION DISTINCT SELECT ProductID FROM LocalOptionGroups WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738)
[0.001667 of 0.030054 / 21]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scDal->getProductsHavingOptions()    ProductListingService.php[317]
scDal->loadProductsHavingOptionsIntoCache()    Dal.php[255]
miUtil::getDBArray()    Dal.php[717]
miStaticDBUtil::execSelect()    Util.php[14]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [22] SELECT ProductID, AVG(ProductRatingVoteValue) AS AverageRating, COUNT(*) AS NumVotes FROM ProductRatingVotes WHERE ProductID IN ("5111","2444","2443","2410","2409","2406","2405","2401","2398","5875","5729","5728","5727","5724","5722","5530","4692","2442","2440","2439","2438","2436","2435","2433","2432","2428","2425","2422","2397","4768","4740","4738") AND ProductRatingVoteStatus = "1" GROUP BY ProductID
[0.001517 of 0.031571 / 22]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scCustomerRatingActionsModule->getRatingsForProducts()    ProductListingService.php[363]
scCustomerRatingActionsModule->getProductRatingAverage()    rating_actions.php[190]
miStaticDBUtil::execSelect()    rating_actions.php[173]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [23] SELECT ProductID, OptionGroupID FROM ProductOptionGroups WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738)
[0.00073 of 0.032301 / 23]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceSection()    ProductListingService.php[390]
scProductPrice::getPriceSection()    ProductListingService.php[877]
scProductPrice::getOriginalPriceSection()    ProductPrice.php[43]
scDal->getProductsOptions()    ProductPrice.php[224]
scDal->loadOptionsIntoCache()    Dal.php[217]
scDal->loadGlobalOptionsIntoCache()    Dal.php[544]
miStaticDBUtil::execSelect()    Dal.php[565]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [24] SELECT ProductID, LocalOptionGroups.LocalOptionGroupID, LocalOptionGroupType, LocalOptionGroupDisplayMode, LocalOptionGroupHasInfoLink, LocalOptionGroupInfoLinkTitle, LocalOptionGroupOnHoverView, LocalOptionGroupOnHoverViewLabel, CMSRichTextPageID, LocalOptionGroupName, LocalOptions.LocalOptionID, LocalOptionPriceModType, LocalOptionPriceModValue, LocalOptionName, LocalOptionRequired, LocalOptionColor, LocalOptionThumb, LocalOptionThumbWidth, LocalOptionThumbHeight FROM LocalOptionGroups LEFT JOIN LocalOptionGroupsML ON (LocalOptionGroups.LocalOptionGroupID = LocalOptionGroupsML.LocalOptionGroupID AND LocalOptionGroupsML.LanguageID = 2) LEFT JOIN LocalOptions ON (LocalOptionGroups.LocalOptionGroupID = LocalOptions.LocalOptionGroupID) LEFT JOIN LocalOptionsML ON (LocalOptions.LocalOptionID = LocalOptionsML.LocalOptionID AND LocalOptionsML.LanguageID = 2) WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 5111, 2444, 2443, 2410, 2409, 2406, 2405, 2401, 2398, 5875, 5729, 5728, 5727, 5724, 5722, 5530, 4692, 2442, 2440, 2439, 2438, 2436, 2435, 2433, 2432, 2428, 2425, 2422, 2397, 4768, 4740, 4738) ORDER BY LocalOptionGroupSort,LocalOptionSort
[0.00164 of 0.033941 / 24]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceSection()    ProductListingService.php[390]
scProductPrice::getPriceSection()    ProductListingService.php[877]
scProductPrice::getOriginalPriceSection()    ProductPrice.php[43]
scDal->getProductsOptions()    ProductPrice.php[224]
scDal->loadOptionsIntoCache()    Dal.php[217]
scDal->loadLocalOptionsIntoCache()    Dal.php[545]
miStaticDBUtil::execSelect()    Dal.php[622]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [25] SELECT ProductID,TaxClassID FROM ProductTaxClasses WHERE ProductID IN ("5676","5675","5674","46","228","230","385","6127","5447","5961","5111","2444","2443","2410","2409","2406","2405","2401","2398","5875","5729","5728","5727","5724","5722","5530","4692","2442","2440","2439","2438","2436","2435","2433","2432","2428","2425","2422","2397","4768","4740","4738","5111")
[0.000784 of 0.034725 / 25]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getPriceSection()    ProductListingService.php[390]
scProductPrice::getPriceSection()    ProductListingService.php[877]
scProductPrice::getOriginalPriceSection()    ProductPrice.php[43]
scProductPrice::getTaxedAmount()    ProductPrice.php[231]
scDal->getProductTaxClasses()    ProductPrice.php[326]
miSqlRecordset->getAllRecords()    Dal.php[206]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[275]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [26] SELECT * FROM ProductCustomerGroups WHERE ProductID IN ("5676","5675","5674","46","228","230","385","6127","5447","5961","5111","2444","2443","2410","2409","2406","2405","2401","2398","5875","5729","5728","5727","5724","5722","5530","4692","2442","2440","2439","2438","2436","2435","2433","2432","2428","2425","2422","2397","4768","4740","4738","5111")
[0.000971 of 0.035696 / 26]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scProductListingService->getCartRelatedSections()    ProductListingService.php[413]
scProductSL->isOutOfStock()    ProductListingService.php[861]
scProductSL->getQuantityRestrictionsForCustomerGroup()    ProductSL.php[179]
scDal->getProductCustomerGroupRestrictions()    ProductSL.php[157]
miSqlRecordset->getAllRecords()    Dal.php[276]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[275]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [27] SELECT *, GROUP_CONCAT(DiscountProducts.ProductID SEPARATOR ",") as ProductIDs, GROUP_CONCAT(DiscountCategories.CategoryID SEPARATOR ",") as CategoryIDs, GROUP_CONCAT(DiscountBrands.BrandID SEPARATOR ",") as BrandIDs, IFNULL(DiscountPromotionDescription, "") AS HTML_DiscountPromotionDescription FROM Discounts LEFT JOIN DiscountProducts USING(DiscountID) LEFT JOIN DiscountCategories USING(DiscountID) LEFT JOIN DiscountBrands USING(DiscountID) LEFT JOIN DiscountsML ON Discounts.DiscountID = DiscountsML.DiscountID AND LanguageID = "2" WHERE Discounts.DiscountIsActive = 1 AND Discounts.DiscountValidFrom <= "2025-04-28 14:31" AND Discounts.DiscountValidTo >= "2025-04-28 14:31" GROUP BY Discounts.DiscountID
[0.001387 of 0.037083 / 27]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scProductListing->getParser()    categories.php[63]
scProductListingService->getSection()    ProductListing.php[82]
scProductListingService->getGridSections()    ProductListingService.php[94]
scPromotionsUtil::getProductCountdownSection()    ProductListingService.php[489]
scDal->getProductPromotionRow()    PromotionsUtil.php[63]
scDal->loadPromotions()    Dal.php[879]
miStaticDBUtil::execSelect()    Dal.php[939]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [28] SELECT B.CategoryID, CategoryName FROM Categories A JOIN Categories B JOIN CategoriesML ON B.CategoryID=CategoriesML.CategoryID WHERE A.CategoryID="78" AND LanguageID="2" AND A.CategoryLeft >= B.CategoryLeft AND A.CategoryRight <= B.CategoryRight ORDER BY B.CategoryLeft
[0.000684 of 0.037767 / 28]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scUIUtil::getCategoriesBreadcrumb()    categories.php[71]
scCategories::getCategoryFullBranch()    UIUtil.php[173]
miStaticDBUtil::execSelect()    Categories.php[46]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [29] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 1 AND CustomUrlEntityID IN (2, 78)
[0.000656 of 0.038423 / 29]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scUIUtil::getCategoriesBreadcrumb()    categories.php[71]
scFriendlyUrl::initFriendlyUrls()    UIUtil.php[178]
scFriendlyUrl::initCategoriesFriendlyUrls()    FriendlyUrl.php[164]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[564]
scCustomUrls::getPrimaryUrl()    FriendlyUrl.php[90]
miStaticDBUtil::execSelect()    CustomUrls.php[44]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [30] SELECT *,IFNULL(CategoryDescription, "") AS HTML_CategoryDescription FROM CategoriesML RIGHT JOIN Categories ON Categories.CategoryID=CategoriesML.CategoryID AND CategoriesML.LanguageID=2 WHERE CategoryParentID="78" AND CategoryStatus="1" AND CategoryDeepProductCount>"0" ORDER BY CategorySort ASC
[0.000698 of 0.039121 / 30]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scCategoryProductListing->parse()    ProductsListingAction.php[14]
scCategoryProductListing->getSubcategoriesSection()    categories.php[73]
miSqlRecordset->getAllRecords()    categories.php[105]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[275]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [31] SELECT CategorySEODescription AS Description, CategorySEOKeywords AS Keywords, CategorySEOTitle AS Title, CategoryName AS PageName FROM CategoriesML LEFT JOIN Categories USING(CategoryID) WHERE CategoriesML.CategoryID = "78" AND LanguageID = "2"
[0.000542 of 0.039663 / 31]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
miDispatcher->process()    UserDisplayController.php[550]
scProductsListingAction->doAction()    Dispatcher.php[37]
scUserDisplayController->getSeo()    ProductsListingAction.php[17]
scCategorySeo->initMetaData()    UserDisplayController.php[95]
miStaticDBUtil::execSelect()    Seo.php[479]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]

debugQuery(): [32] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 1 AND CustomUrlEntityID IN (250, 251, 252, 65, 554)
[0.000478 of 0.040141 / 32]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getHeader()    UserDisplayController.php[514]
scUserMenus::getMenuTemplateSection()    UserDisplayController.php[230]
scUserMenus::getMenuItems()    UserMenus.php[129]
scUserMenus::setUrls()    UserMenus.php[86]
scFriendlyUrl::initFriendlyUrls()    UserMenus.php[122]
scFriendlyUrl::initMenuItemsFriendlyUrls()    FriendlyUrl.php[185]
scFriendlyUrl::initBannerOrMenuFriendlyUrls()    FriendlyUrl.php[597]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[658]
scCustomUrls::getPrimaryUrl()    FriendlyUrl.php[90]
miStaticDBUtil::execSelect()    CustomUrls.php[44]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]
ФЕНЕР VARTA
BGN
  • BGN
  • EUR
Разширено търсене
0
Меню
Профил
Език
НачалоФЕНЕРИVARTA

Филтри

Varta Professional Line

Varta Easy Line

Varta Power Line

Страница 1 от 2
«1 2»

Тотална разпродажба

Нови продукти

Абонирай се

Най-продавани

Марки

Върни До Горе
Total MySQL time: 0.040141
Total MySQL queires: 32