debugQuery(): [1] SELECT * FROM RedirectUrls WHERE RedirectUrlFrom = "/%D0%B1%D0%B0%D1%82%D0%B5%D1%80%D0%B8%D1%8F-%D0%B7%D0%B0-gps-%D0%BD%D0%B0%D0%B2%D0%B8%D0%B3%D0%B0%D1%86%D0%B8%D1%8F.html?page=1" LIMIT 1
[0.000712 of 0.000712 / 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 Currencies JOIN CurrenciesML ON Currencies.CurrencyID=CurrenciesML.CurrencyID WHERE Currencies.CurrencyID = "6" AND LanguageID="2"
[0.000683 of 0.001395 / 2]


scCustomUrlResolver->resolve()    custom_url.php[12]
scUrlResolver->resolve()    custom_url.php[34]
scUrlResolver->resolveTempletizedUrl()    UrlResolver.php[563]
scSeoUrlTypes::splitUrlOfType()    UrlResolver.php[608]
scCurrencyUtil::getBaseCurrencyCode()    SeoUrlTypes.php[89]
scCurrencyUtil::getBaseCurrency()    CurrencyUtil.php[178]
scCurrency->__construct()    CurrencyUtil.php[160]
scCurrency->readCurrencyById()    Currency.php[18]
miStaticDBUtil::execSelect()    Currency.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [3] SELECT * FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlHash="667771758"
[0.000775 of 0.00217 / 3]


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(): [4] SELECT Currencies.CurrencyID, CurrencyCode, COALESCE(CurrencyName, CurrencyCode) AS CurrencyName FROM Currencies LEFT JOIN CurrenciesML ON Currencies.CurrencyID=CurrenciesML.CurrencyID AND LanguageID=2 WHERE CurrencyIsActive AND (CurrencyRateLastUpdated > 881924400) OR Currencies.CurrencyID="6" ORDER BY CurrencySort
[0.000873 of 0.003043 / 4]


scCustomUrlResolver->resolve()    custom_url.php[12]
scCurrencyUtil::setCurrentCurrency()    custom_url.php[93]
scCurrencyUtil::loadCurrencies()    CurrencyUtil.php[302]
miStaticDBUtil::execSelect()    CurrencyUtil.php[214]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [5] SELECT *,TextsTranslated.TextID AS TextID FROM TextsCache LEFT JOIN TextsTranslated USING(TextID) WHERE TextsCachePagePath = "categories.php" AND LanguageID = "2"
[0.004886 of 0.007929 / 5]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scCategorySeo->__construct()    categories.php[202]
_c()    Seo.php[473]
scInterfaceTexts::singleton()    Init.php[220]
scInterfaceTexts->__construct()    InterfaceTexts.php[15]
scInterfaceTexts->loadTexts()    InterfaceTexts.php[33]
miStaticDBUtil::execSelect()    InterfaceTexts.php[100]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [6] SELECT LanguageID,CategoryName FROM CategoriesML WHERE CategoryID="576"
[0.000768 of 0.008697 / 6]


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(): [7] SELECT CustomUrlEntityCode, LanguageID, CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent LIMIT 100
[0.001636 of 0.010333 / 7]


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]
scCustomUrls::precache()    CustomUrls.php[31]
miStaticDBUtil::execSelect()    CustomUrls.php[63]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [8] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 1 AND CustomUrlEntityID IN (576)
[0.000697 of 0.01103 / 8]


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(): [9] SELECT CMSLayoutID FROM CMSLayoutsXPages WHERE SkinID="105" AND CategoryID="576"
[0.000607 of 0.011637 / 9]


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(): [10] SELECT CMSDynamicPageID, CMSDynamicPageCode, CMSDynamicPagePath, CMSDynamicPageName FROM CMSDynamicPages ORDER BY CMSDynamicPageName
[0.000638 of 0.012275 / 10]


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]
scDynamicPageLayout->getLayoutId()    Layout.php[146]
scLayoutUtil::getPageLayout()    Layout.php[78]
scDynamicPages::getPageIdByCode()    LayoutUtil.php[430]
scDynamicPages::getPages()    DynamicPages.php[54]
miStaticDBUtil::execSelect()    DynamicPages.php[78]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [11] SELECT CMSLayoutID FROM CMSLayoutsXPages WHERE SkinID="105" AND CMSDynamicPageID="2"
[0.000552 of 0.012827 / 11]


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]
scDynamicPageLayout->getLayoutId()    Layout.php[146]
scLayoutUtil::getPageLayout()    Layout.php[78]
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(): [12] SELECT CMSBoxID,CMSMenuItemID,ModuleClassID,CMSBoxClassNames,CMSMegaMenuPositionNumber,CMSMegaMenuPositionOptions,CMSBoxTitle FROM CMSMegaMenuPositions LEFT JOIN CMSMegaMenuPositionsML ON CMSMegaMenuPositions.CMSMegaMenuPositionID=CMSMegaMenuPositionsML.CMSMegaMenuPositionID AND CMSMegaMenuPositionsML.LanguageID=2
[0.000623 of 0.01345 / 12]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::initMegaItemBoxes()    LayoutUtil.php[289]
scDal->getAllCmsMenuItemPositions()    LayoutUtil.php[294]
scDal->loadCmsMenuItemPositions()    Dal.php[830]
miSqlRecordset->getAllRecords()    Dal.php[839]
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(): [13] SELECT * FROM ModuleClasses WHERE ModuleClassID="53"
[0.00045 of 0.0139 / 13]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::initMegaItemBoxes()    LayoutUtil.php[289]
scModulesFactory::loadClass()    LayoutUtil.php[302]
miSqlRecord->readPK()    ModulesFactory.php[60]
miSqlRecord->read()    SqlRecord.php[68]
miStaticDBUtil::execSelect()    SqlRecord.php[60]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [14] SELECT * FROM CMSLayouts WHERE CMSLayoutID="210"
[0.00047 of 0.01437 / 14]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::getBoxes()    LayoutUtil.php[290]
scLayoutUtil::getCustomerBoxes()    LayoutUtil.php[283]
scLayoutUtil::readLayoutBoxes()    LayoutUtil.php[566]
scLayoutUtil::getLayoutType()    LayoutUtil.php[591]
scDal->getLayoutType()    LayoutUtil.php[316]
scDal->getLayoutRowById()    Dal.php[86]
miStaticDBUtil::execSelect()    Dal.php[99]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [15] SELECT CMSLayoutBoxes.CMSLayoutBoxColumn,CMSLayoutBoxes.CMSLayoutBoxSort,CMSBoxes.CMSBoxID,CMSBoxesML.CMSBoxTitle,ModuleClasses.ModuleClassName,ModuleClasses.ModuleClassLocation,Modules.ModuleName,Modules.ModuleID,CMSBoxCssClass FROM CMSLayoutBoxes INNER JOIN CMSBoxes USING(CMSBoxID) INNER JOIN ModuleClasses USING(ModuleClassID) INNER JOIN Modules USING(ModuleID) LEFT JOIN CMSBoxesML ON CMSBoxes.CMSBoxID = CMSBoxesML.CMSBoxID AND LanguageID = 2 WHERE CMSLayoutID="210" AND CMSBoxIsActive!="0" ORDER BY CMSLayoutBoxSort ASC
[0.001087 of 0.015457 / 15]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::getBoxes()    LayoutUtil.php[290]
scLayoutUtil::getCustomerBoxes()    LayoutUtil.php[283]
scLayoutUtil::readLayoutBoxes()    LayoutUtil.php[566]
miSqlRecordset->getAllRecords()    LayoutUtil.php[601]
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(): [16] SELECT * FROM CMSBoxOptions WHERE CMSBoxID IN ("1654","1659","1661","1655","1667","627")
[0.000584 of 0.016042 / 16]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::getBoxes()    LayoutUtil.php[290]
scLayoutUtil::getCustomerBoxes()    LayoutUtil.php[283]
scLayoutUtil::readLayoutBoxes()    LayoutUtil.php[566]
scLayoutUtil::getBox()    LayoutUtil.php[609]
scCustomerNewProductsBox->__construct()    LayoutUtil.php[442]
scModuleOptions::getCmsBoxOptions()    new_products_box.php[18]
scCmsBoxOptionsHelper->getOptions()    ModuleOptions.php[47]
scDal->getSLCmsBoxOptions()    ModuleOptions.php[253]
scDal->loadSLCmsBoxOptionsIntoCache()    Dal.php[387]
scDal->loadSLCmsBoxOptions()    Dal.php[440]
miSqlRecordset->getAllRecords()    Dal.php[446]
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(): [17] SELECT Products.*, ProductsML.ProductName, ProductsML.ProductDescription, ProductImages.ProductImageBox AS ProductImageBox,ProductImages.ProductImageBoxWidth AS ProductImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductImageBoxCdn,ProductImages.ProductImage AS ProductImage,ProductImages.ProductImageWidth AS ProductImageWidth,ProductImages.ProductImageHeight AS ProductImageHeight,ProductImages.ProductImageSize AS ProductImageSize,ProductImages.ProductImageCdn AS ProductImageCdn,ProductImagesML.ProductImageAlt,ProductImages.ProductImageBox AS ProductVariantImageBox,ProductImages.ProductImageBoxWidth AS ProductVariantImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductVariantImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductVariantImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductVariantImageBoxCdn,ProductImages.ProductImage AS ProductVariantImage,ProductImages.ProductImageWidth AS ProductVariantImageWidth,ProductImages.ProductImageHeight AS ProductVariantImageHeight,ProductImages.ProductImageSize AS ProductVariantImageSize,ProductImages.ProductImageCdn AS ProductVariantImageCdn,ProductImagesML.ProductImageAlt, ProductVariants.ProductVariantID AS ProductVariantID, ProductVariants.ProductVariantCode, ProductVariants.ProductVariantWeight, ProductVariants.ProductVariantQuantity, ProductVariants.ProductVariantPrice, ProductVariants.ProductVariantAvailabilityStatus, Products.ProductID as ProductID FROM Products LEFT JOIN ProductsML ON(Products.ProductID=ProductsML.ProductID AND LanguageID = "2") LEFT JOIN ProductImages ON (Products.ProductDefaultImageID = ProductImages.ProductImageID) LEFT JOIN ProductImagesML ON (ProductImages.ProductImageID = ProductImagesML.ProductImageID AND ProductImagesML.LanguageID="2") LEFT JOIN ProductVariants ON (ProductVariants.ProductID = Products.ProductID AND ProductVariantIsDefault<>0) WHERE Products.ProductIsActive IN ("1","3") AND Products.ProductCreatedTimestamp >= 1740654000 AND Products.ProductIsVariant = 0 ORDER BY Products.ProductCreatedTimestamp DESC LIMIT 3
[0.001904 of 0.017946 / 17]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::getBoxes()    LayoutUtil.php[290]
scLayoutUtil::getCustomerBoxes()    LayoutUtil.php[283]
scLayoutUtil::readLayoutBoxes()    LayoutUtil.php[566]
scCustomerNewProductsBox->getDisplayedProductIds()    LayoutUtil.php[623]
scCustomerNewProductsBox->getProducts()    new_products_box.php[92]
miStaticDBUtil::execSelect()    new_products_box.php[86]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [18] SELECT Products.*, ProductsML.ProductName, ProductsML.ProductDescription, ProductImages.ProductImageBox AS ProductImageBox,ProductImages.ProductImageBoxWidth AS ProductImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductImageBoxCdn,ProductImages.ProductImage AS ProductImage,ProductImages.ProductImageWidth AS ProductImageWidth,ProductImages.ProductImageHeight AS ProductImageHeight,ProductImages.ProductImageSize AS ProductImageSize,ProductImages.ProductImageCdn AS ProductImageCdn,ProductImagesML.ProductImageAlt,ProductImages.ProductImageBox AS ProductVariantImageBox,ProductImages.ProductImageBoxWidth AS ProductVariantImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductVariantImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductVariantImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductVariantImageBoxCdn,ProductImages.ProductImage AS ProductVariantImage,ProductImages.ProductImageWidth AS ProductVariantImageWidth,ProductImages.ProductImageHeight AS ProductVariantImageHeight,ProductImages.ProductImageSize AS ProductVariantImageSize,ProductImages.ProductImageCdn AS ProductVariantImageCdn,ProductImagesML.ProductImageAlt, ProductVariants.ProductVariantID AS ProductVariantID, ProductVariants.ProductVariantCode, ProductVariants.ProductVariantWeight, ProductVariants.ProductVariantQuantity, ProductVariants.ProductVariantPrice, ProductVariants.ProductVariantAvailabilityStatus, Products.ProductID as ProductID FROM Bestsellers INNER JOIN Products USING(ProductID) LEFT JOIN ProductsML ON(Products.ProductID=ProductsML.ProductID AND LanguageID = "2") LEFT JOIN ProductImages ON (Products.ProductDefaultImageID = ProductImages.ProductImageID) LEFT JOIN ProductImagesML ON (ProductImages.ProductImageID = ProductImagesML.ProductImageID AND ProductImagesML.LanguageID="2") LEFT JOIN ProductVariants ON (ProductVariants.ProductID = Products.ProductID AND ProductVariantIsDefault<>0) WHERE BestsellerListBy = "2" AND Products.ProductIsActive IN ("1","3") AND Products.ProductIsVariant = 0 ORDER BY BestsellerSort LIMIT 3
[0.001423 of 0.019368 / 18]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scLayoutUtil::initCustomerAreaBoxes()    UserDisplayController.php[547]
scLayoutUtil::getBoxes()    LayoutUtil.php[290]
scLayoutUtil::getCustomerBoxes()    LayoutUtil.php[283]
scLayoutUtil::readLayoutBoxes()    LayoutUtil.php[566]
scCustomerBestSellersBox->getDisplayedProductIds()    LayoutUtil.php[623]
scCustomerBestSellersBox->getProducts()    bestsellers_box.php[220]
miStaticDBUtil::execSelect()    bestsellers_box.php[215]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [19] SELECT * FROM ModuleClasses INNER JOIN Modules ON ModuleClasses.ModuleID = Modules.ModuleID WHERE ModuleClassInterface IN ("ITemplateFilter","IProductsListingFilter","IProductPriceModifier","IProductDetails","ICartObserver") AND ModuleIsActive="1"
[0.002926 of 0.022295 / 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]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scProductListing->applyFilterToSearch()    ProductListing.php[49]
scProductsListingFilters->getFilters()    ProductListing.php[183]
scModulesFactory::getImplementations()    IProductsListingFilter.php[35]
miSqlRecordset->getRecords()    ModulesFactory.php[179]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[263]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [20] SELECT Attributes.AttributeID,AttributeSort,AttributeCode,AttributeName,AttributeType,AttributeValidator,AttributeUnit,AttributeApplyToAllProducts,AttributeShowInTab,AttributeShowAfterDescription,AttributeIsSearchable,AttributeIsComparable,AttributeShowInQuickView,AttributeShowOnHover,AttributeIsFilterable,AttributeFilterWidget,AttributeFilterWidgetShowCounts,AttributeFilterWidgetHideIrrelevant,AttributeFilterMoveOutWhenApplied FROM AttributesML RIGHT JOIN Attributes ON Attributes.AttributeID=AttributesML.AttributeID AND AttributesML.LanguageID=2 ORDER BY AttributeSort ASC
[0.00078 of 0.023074 / 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]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scProductListing->applyFilterToSearch()    ProductListing.php[49]
scProductListing->setStatePersistVars()    ProductListing.php[185]
scProductsFilterAttributes->getFilterVars()    ProductListing.php[207]
scProductsFilterAttributes->getAttributes()    products_filter_attributes.php[36]
scAttributesRetriever->getAttributes()    products_filter_attributes.php[154]
scAttributesRetriever->getAllAttributes()    AttributesRetriever.php[36]
scDal->getAttributes()    AttributesRetriever.php[87]
scDal->loadAttributesIntoCache()    Dal.php[140]
miSqlRecordset->getRecords()    Dal.php[496]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[263]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [21] SELECT DISTINCTROW ProductClassID, AttributeID FROM ProductClassXAttributes JOIN Products USING(ProductClassID) WHERE ProductID IN(5676,5675,5674,46,228,230,385,6127,5447,5961) ORDER BY ProductClassXAttributeSort
[0.000819 of 0.023893 / 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]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scProductListing->applyFilterToSearch()    ProductListing.php[49]
scProductListing->setStatePersistVars()    ProductListing.php[185]
scProductsFilterAttributes->getFilterVars()    ProductListing.php[207]
scProductsFilterAttributes->getAttributes()    products_filter_attributes.php[36]
scAttributesRetriever->getAttributes()    products_filter_attributes.php[154]
scAttributesRetriever->getAllAttributes()    AttributesRetriever.php[36]
scDal->getAttributes()    AttributesRetriever.php[87]
scDal->loadAttributesIntoCache()    Dal.php[140]
miStaticDBUtil::execSelect()    Dal.php[520]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [22] SELECT * FROM AttributeOptionsML RIGHT JOIN AttributeOptions ON AttributeOptions.AttributeOptionID=AttributeOptionsML.AttributeOptionID AND AttributeOptionsML.LanguageID=2 WHERE AttributeID IN ("2","7","8") ORDER BY AttributeOptionSort ASC
[0.000839 of 0.024732 / 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]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scProductListing->applyFilterToSearch()    ProductListing.php[49]
scProductListing->setStatePersistVars()    ProductListing.php[185]
scProductsFilterAttributes->getFilterVars()    ProductListing.php[207]
scProductsFilterAttributes->getAttributes()    products_filter_attributes.php[36]
scAttributesRetriever->getAttributes()    products_filter_attributes.php[154]
scAttributesRetriever->addAttributesInfo()    AttributesRetriever.php[39]
scAttributesRetriever->getAttributeOptions()    AttributesRetriever.php[144]
miSqlRecordset->getAllRecords()    AttributesRetriever.php[173]
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(): [23] SELECT * FROM OptionGroupsML RIGHT JOIN OptionGroups ON OptionGroups.OptionGroupID=OptionGroupsML.OptionGroupID AND OptionGroupsML.LanguageID=2 WHERE OptionGroupIsFilterable="1" ORDER BY OptionGroupSort ASC
[0.000711 of 0.025443 / 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]
scViewCategoryAction->getListing()    ProductsListingAction.php[10]
scCategoryProductListing->__construct()    categories.php[198]
scProductListing->__construct()    categories.php[26]
scProductListing->getListingItems()    ProductListing.php[32]
scProductListing->applyFilterToSearch()    ProductListing.php[49]
scProductListing->setStatePersistVars()    ProductListing.php[185]
scProductsFilterOptions->getFilterVars()    ProductListing.php[207]
scProductOptionsFilterHelper->getOptions()    products_filter_options.php[36]
scDal->getFilterableOptionGroups()    ProductOptionsFilterHelper.php[33]
miSqlRecordset->getAllRecords()    Dal.php[339]
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(): [24] 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="576"
[0.000675 of 0.026118 / 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]
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(): [25] SELECT B.CategoryID FROM Categories A JOIN Categories B WHERE A.CategoryID=576 AND A.CategoryLeft <= B.CategoryLeft AND A.CategoryRight >= B.CategoryRight ORDER BY B.CategoryLeft
[0.000706 of 0.026824 / 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]
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(): [26] 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(576,289,577,578,579,580,581,582,658,659,660) 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(576,289,577,578,579,580,581,582,658,659,660) GROUP BY ProductID)) AS Products GROUP BY ProductID ORDER BY ProductCreatedTimestamp DESC, ProductID DESC LIMIT 0, 32
[0.003641 of 0.030466 / 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]
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(): [27] 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 ("6094","6093","6091","6090","6089","6088","6087","6086","6085","6084","6083","6082","6081","6080","6079","6078","6077","6076","6075","6074","6073","6072","6071","6070","6069","6068","6067","6066","6065","6064","6063","6062") AND Products.ProductIsVariant="0" GROUP BY Products.ProductID
[0.00268 of 0.033146 / 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]
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(): [28] 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 = "576" AND ProductIsActive IN ("1","3") ORDER BY ProductCreatedTimestamp DESC
[0.001317 of 0.034463 / 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]
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(): [29] 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(576,289,577,578,579,580,581,582,658,659,660) 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(576,289,577,578,579,580,581,582,658,659,660) GROUP BY ProductID)) AS Products
[0.00304 of 0.037503 / 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]
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(): [30] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 2 AND CustomUrlEntityID IN (6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062)
[0.001658 of 0.039161 / 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]
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(): [31] 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 (6094,6093,6091,6090,6089,6088,6087,6086,6085,6084,6083,6082,6081,6080,6079,6078,6077,6076,6075,6074,6073,6072,6071,6070,6069,6068,6067,6066,6065,6064,6063,6062,6094,6093,6091,6090,6089,6088,6087,6086,6085,6084,6083,6082,6081,6080,6079,6078,6077,6076,6075,6074,6073,6072,6071,6070,6069,6068,6067,6066,6065,6064,6063,6062))
[0.001715 of 0.040876 / 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]
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(): [32] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 6 AND CustomUrlEntityID IN (127)
(simil: 2)
[0.000613 of 0.041489 / 32]


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(): [33] 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,6094,6093,6091,6090,6089,6088,6087,6086,6085,6084,6083,6082,6081,6080,6079,6078,6077,6076,6075,6074,6073,6072,6071,6070,6069,6068,6067,6066,6065,6064,6063,6062,6094,6093,6091,6090,6089,6088,6087,6086,6085,6084,6083,6082,6081,6080,6079,6078,6077,6076,6075,6074,6073,6072,6071,6070,6069,6068,6067,6066,6065,6064,6063,6062)) AND LanguageID = 2
[0.000891 of 0.04238 / 33]


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(): [34] SELECT ModuleID FROM Modules WHERE ModuleName="com.summercart.wishlist" LIMIT 1
[0.000446 of 0.042826 / 34]


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]
scModulesFactory::getModuleIdByName()    ProductListingService.php[82]
scUtil::getDbValue()    ModulesFactory.php[25]
miStaticDBUtil::execSelect()    Util.php[48]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [35] SELECT * FROM SkinSettings WHERE SkinID="105"
[0.000695 of 0.043521 / 35]


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]
scWishlistProductsDetails->getProductListHtml()    ProductListingService.php[87]
scWishlistProductsDetails->getListBoxHtml()    wishlist.php[149]
scTemplateParser->templateParse()    wishlist.php[205]
scTemplateParser->assignSystemVariables()    TemplateParser.php[86]
scSkin->getTemplateVars()    TemplateParser.php[163]
scSkinSettingsUtil::getSkinSettings()    Skins.php[534]
miSqlRecordset->getAllRecords()    SkinSettingsUtil.php[421]
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(): [36] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 10 AND CustomUrlEntityID IN (26, 49, 23, 28, 11, 30, 9, 48, 1, 8, 37, 39, 25, 19, 13, 29, 12, 21, 18, 41, 10, 6, 4, 38, 20, 46)
[0.000996 of 0.044517 / 36]


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]
scWishlistProductsDetails->getProductListHtml()    ProductListingService.php[87]
scWishlistProductsDetails->getListBoxHtml()    wishlist.php[149]
scTemplateParser->templateParse()    wishlist.php[205]
scTemplateParser->assignSystemVariables()    TemplateParser.php[86]
scTemplateParser->getAssignableUrls()    TemplateParser.php[167]
scFriendlyUrl::get()    TemplateParser.php[181]
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(): [37] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 10 AND CustomUrlEntityID IN (40)
(simil: 3)
[0.000598 of 0.045115 / 37]


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]
scWishlistProductsDetails->getProductListHtml()    ProductListingService.php[87]
scWishlistProductsDetails->getListBoxHtml()    wishlist.php[149]
scTemplateParser->templateParse()    wishlist.php[205]
scTemplateParser->assignSystemVariables()    TemplateParser.php[86]
scTemplateParser->getAssignableUrls()    TemplateParser.php[167]
scFriendlyUrl::get()    TemplateParser.php[182]
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(): [38] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 10 AND CustomUrlEntityID IN (32)
(simil: 4)
[0.000594 of 0.045709 / 38]


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]
scWishlistProductsDetails->getProductListHtml()    ProductListingService.php[87]
scWishlistProductsDetails->getListBoxHtml()    wishlist.php[149]
scTemplateParser->templateParse()    wishlist.php[205]
scTemplateParser->assignSystemVariables()    TemplateParser.php[86]
scTemplateParser->getAssignableUrls()    TemplateParser.php[167]
scFriendlyUrl::get()    TemplateParser.php[182]
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(): [39] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 10 AND CustomUrlEntityID IN (43)
(simil: 5)
[0.000594 of 0.046303 / 39]


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]
scWishlistProductsDetails->getProductListHtml()    ProductListingService.php[87]
scWishlistProductsDetails->getListBoxHtml()    wishlist.php[149]
scTemplateParser->templateParse()    wishlist.php[205]
scTemplateParser->assignSystemVariables()    TemplateParser.php[86]
scTemplateParser->getAssignableUrls()    TemplateParser.php[167]
scFriendlyUrl::get()    TemplateParser.php[182]
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(): [40] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 6 AND CustomUrlEntityID IN (81)
(simil: 6)
[0.000879 of 0.047182 / 40]


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(): [41] 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 (6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062) ORDER BY OptionGroupSort, OptionSort
[0.001258 of 0.04844 / 41]


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(): [42] 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 (6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062) ORDER BY LocalOptionGroupSort,LocalOptionSort
[0.001302 of 0.049742 / 42]


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(): [43] (SELECT ProductID, CategoryID FROM Products WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062))UNION ALL (SELECT ProductID, CategoryID FROM ProductXCategories WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062))
[0.002224 of 0.051966 / 43]


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(): [44] SET group_concat_max_len = 1000000
[0.000262 of 0.052228 / 44]


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(): [45] 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:29" AND DiscountValidTo >= "2025-04-28 14:29" ORDER BY DiscountSort ASC
[0.001837 of 0.054065 / 45]


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(): [46] SELECT ProductID FROM ProductOptionGroups WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062) UNION DISTINCT SELECT ProductID FROM LocalOptionGroups WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062)
[0.001502 of 0.055568 / 46]


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(): [47] SELECT ModuleID FROM Modules WHERE ModuleName="com.summercart.productcomparison" LIMIT 1
[0.000412 of 0.055979 / 47]


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]
scModulesFactory::getModuleIdByName()    ProductListingService.php[336]
scUtil::getDbValue()    ModulesFactory.php[25]
miStaticDBUtil::execSelect()    Util.php[48]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [48] SELECT ModuleID FROM Modules WHERE ModuleName="com.summercart.ratingactions" LIMIT 1
[0.000391 of 0.05637 / 48]


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]
scModulesFactory::getModuleIdByName()    ProductListingService.php[352]
scUtil::getDbValue()    ModulesFactory.php[25]
miStaticDBUtil::execSelect()    Util.php[48]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [49] SELECT * FROM ModuleClasses INNER JOIN Modules ON Modules.ModuleID = ModuleClasses.ModuleID AND ModuleIsActive WHERE ModuleClasses.ModuleID="35" AND ModuleClassInterface="IUserModule"
[0.000602 of 0.056973 / 49]


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]
scModulesFactory::getImplementation()    ProductListingService.php[353]
scModulesFactory::getModuleClass()    ModulesFactory.php[140]
miSqlRecordset->getAllRecords()    ModulesFactory.php[517]
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(): [50] SELECT ProductID, AVG(ProductRatingVoteValue) AS AverageRating, COUNT(*) AS NumVotes FROM ProductRatingVotes WHERE ProductID IN ("6094","6093","6091","6090","6089","6088","6087","6086","6085","6084","6083","6082","6081","6080","6079","6078","6077","6076","6075","6074","6073","6072","6071","6070","6069","6068","6067","6066","6065","6064","6063","6062") AND ProductRatingVoteStatus = "1" GROUP BY ProductID
[0.001025 of 0.057997 / 50]


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(): [51] SELECT ProductID, OptionGroupID FROM ProductOptionGroups WHERE ProductID IN (5676, 5675, 5674, 46, 228, 230, 385, 6127, 5447, 5961, 6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062)
[0.000741 of 0.058738 / 51]


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(): [52] 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, 6094, 6093, 6091, 6090, 6089, 6088, 6087, 6086, 6085, 6084, 6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6066, 6065, 6064, 6063, 6062) ORDER BY LocalOptionGroupSort,LocalOptionSort
[0.001594 of 0.060332 / 52]


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(): [53] SELECT ProductID,TaxClassID FROM ProductTaxClasses WHERE ProductID IN ("5676","5675","5674","46","228","230","385","6127","5447","5961","6094","6093","6091","6090","6089","6088","6087","6086","6085","6084","6083","6082","6081","6080","6079","6078","6077","6076","6075","6074","6073","6072","6071","6070","6069","6068","6067","6066","6065","6064","6063","6062","6094")
[0.000797 of 0.061129 / 53]


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(): [54] SELECT * FROM ProductCustomerGroups WHERE ProductID IN ("5676","5675","5674","46","228","230","385","6127","5447","5961","6094","6093","6091","6090","6089","6088","6087","6086","6085","6084","6083","6082","6081","6080","6079","6078","6077","6076","6075","6074","6073","6072","6071","6070","6069","6068","6067","6066","6065","6064","6063","6062","6094")
[0.000947 of 0.062076 / 54]


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(): [55] 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:29" AND Discounts.DiscountValidTo >= "2025-04-28 14:29" GROUP BY Discounts.DiscountID
[0.001245 of 0.063321 / 55]


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(): [56] SELECT TextID, TextTranslated FROM TextsTranslated WHERE TextIsTranslated = 1 AND TextOriginalHash = "3820077139" AND LanguageID = "2"
[0.000453 of 0.063774 / 56]


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]
_c()    ProductListingService.php[512]
scInterfaceTexts->getText()    Init.php[222]
miStaticDBUtil::execSelect()    InterfaceTexts.php[71]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [57] SELECT TextID FROM Texts WHERE TextOriginalHash = "3820077139"
[0.000354 of 0.064128 / 57]


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]
_c()    ProductListingService.php[512]
scInterfaceTexts->getText()    Init.php[222]
miStaticDBUtil::execSelect()    InterfaceTexts.php[74]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [58] SELECT TextID, TextTranslated FROM TextsTranslated WHERE TextIsTranslated = 1 AND TextOriginalHash = "302350873" AND LanguageID = "2"
(simil: 2)
[0.000387 of 0.064515 / 58]


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]
scProductListing->assignPagerVars()    ProductListing.php[87]
scCustomerAreaPager::getConstDropdown()    ProductListing.php[149]
_c()    CustomerAreaPager.php[167]
scInterfaceTexts->getText()    Init.php[222]
miStaticDBUtil::execSelect()    InterfaceTexts.php[71]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [59] SELECT TextID FROM Texts WHERE TextOriginalHash = "302350873"
(simil: 2)
[0.000345 of 0.06486 / 59]


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]
scProductListing->assignPagerVars()    ProductListing.php[87]
scCustomerAreaPager::getConstDropdown()    ProductListing.php[149]
_c()    CustomerAreaPager.php[167]
scInterfaceTexts->getText()    Init.php[222]
miStaticDBUtil::execSelect()    InterfaceTexts.php[74]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [60] SELECT ProductID, AVG(ProductRatingVoteValue) AS AverageRating, COUNT(*) AS NumVotes FROM ProductRatingVotes WHERE ProductID IN ("") AND ProductRatingVoteStatus = "1" GROUP BY ProductID
[0.000539 of 0.065399 / 60]


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]
scProductService::getProductSections()    categories.php[68]
scProductListingService->getSection()    ProductService.php[175]
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(): [61] SELECT B.CategoryID, CategoryName FROM Categories A JOIN Categories B JOIN CategoriesML ON B.CategoryID=CategoriesML.CategoryID WHERE A.CategoryID="576" AND LanguageID="2" AND A.CategoryLeft >= B.CategoryLeft AND A.CategoryRight <= B.CategoryRight ORDER BY B.CategoryLeft
[0.001065 of 0.066464 / 61]


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(): [62] SELECT *,IFNULL(CategoryDescription, "") AS HTML_CategoryDescription FROM CategoriesML RIGHT JOIN Categories ON Categories.CategoryID=CategoriesML.CategoryID AND CategoriesML.LanguageID=2 WHERE CategoryParentID="576" AND CategoryStatus="1" AND CategoryDeepProductCount>"0" ORDER BY CategorySort ASC
[0.000896 of 0.06736 / 62]


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(): [63] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 1 AND CustomUrlEntityID IN (576, 580, 658, 659, 289, 577, 579, 660, 581, 578, 582)
[0.000917 of 0.068277 / 63]


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]
scFriendlyUrl::initFriendlyUrls()    categories.php[106]
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(): [64] SELECT * FROM CMSDynamicPageAreasML RIGHT JOIN CMSDynamicPageAreas ON CMSDynamicPageAreas.CMSDynamicPageAreaID=CMSDynamicPageAreasML.CMSDynamicPageAreaID AND CMSDynamicPageAreasML.LanguageID=2 WHERE CMSDynamicPageID="2"
[0.000576 of 0.068853 / 64]


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]
scDynamicPages::getTemplateVars()    categories.php[77]
miSqlRecordset->getAllRecords()    DynamicPages.php[16]
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(): [65] SELECT CMSDynamicPageSEODescription AS Description, CMSDynamicPageSEOKeywords AS Keywords, CMSDynamicPageSEOTitle AS Title, CMSDynamicPageTitle AS PageName FROM CMSDynamicPages INNER JOIN CMSDynamicPagesML USING(CMSDynamicPageID) WHERE CMSDynamicPageCode = "com.summercart.dynamic_page.categories" AND LanguageID = "2" LIMIT 1
[0.00056 of 0.069413 / 65]


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]
scDynamicPageSeo->initMetaData()    Seo.php[477]
miStaticDBUtil::execSelect()    Seo.php[395]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


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


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(): [67] SELECT BannerID FROM Banners JOIN ModuleClasses USING(ModuleClassID) WHERE ModuleClassName = "scBannerNivoslider" AND CMSBoxID IN (SELECT CMSBoxID FROM CMSLayoutBoxes JOIN CMSLayouts USING(CMSLayoutID) WHERE CMSLayouts.SkinID = "105")
[0.000697 of 0.070605 / 67]


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]
scCssJsGenerator->getGeneratedFilename()    UserDisplayController.php[126]
scCssGenerator->isGeneratedFileStale()    CssGenerator.php[73]
scCssGenerator->getAllCssFiles()    CssGenerator.php[822]
scCssGenerator->getFragmentsCssFiles()    CssGenerator.php[651]
miStaticDBUtil::execSelect()    CssGenerator.php[524]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [68] SELECT * FROM Skins WHERE SkinID="105"
[0.000394 of 0.070999 / 68]


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]
scCssJsGenerator->getGeneratedFilename()    UserDisplayController.php[126]
scCssGenerator->isGeneratedFileStale()    CssGenerator.php[73]
scCssGenerator->getAllCssFiles()    CssGenerator.php[822]
scCssGenerator->getFragmentsCssFiles()    CssGenerator.php[651]
scCssGenerator->getDesignEditorButtonSchema()    CssGenerator.php[538]
miDefaultDomainObject->read()    CssGenerator.php[792]
miSqlRecord->readPK()    DomainObject.php[46]
miSqlRecord->read()    SqlRecord.php[68]
miStaticDBUtil::execSelect()    SqlRecord.php[60]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [69] SELECT * FROM UpsellSettings WHERE UpsellSettingViewMode = "1" AND UpsellSettingIsActive = "1"
[0.000403 of 0.071402 / 69]


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]
scUpsellUtil::getUpsellPopupHeadSection()    UserDisplayController.php[203]
miStaticDBUtil::execSelect()    UpsellUtil.php[28]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [70] SELECT * FROM UpsellSettings WHERE UpsellSettingViewMode = "0" AND UpsellSettingIsActive = "1"
(simil: 2)
[0.000384 of 0.071785 / 70]


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]
scUpsellUtil::getUpsellPopupHeadSection()    UserDisplayController.php[203]
miStaticDBUtil::execSelect()    UpsellUtil.php[30]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [71] SELECT CMSLayoutCssClassNames FROM CMSLayouts WHERE CMSLayoutID="210" LIMIT 1
[0.000357 of 0.072142 / 71]


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]
scLayout->getBodyClasses()    UserDisplayController.php[215]
scLayoutUtil::getLayoutCssClassNames()    Layout.php[28]
scUtil::getDbValue()    LayoutUtil.php[560]
miStaticDBUtil::execSelect()    Util.php[48]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [72] SELECT StorefrontCssClass FROM Storefronts WHERE StorefrontID="0" LIMIT 1
[0.000345 of 0.072487 / 72]


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]
scUtil::getDbValue()    UserDisplayController.php[222]
miStaticDBUtil::execSelect()    Util.php[48]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [73] SELECT CMSMenus.CMSMenuID, CMSMenus.CMSMenuName, CMSMenus.CMSMenuLocation, CMSMenusML.CMSMenuTitle, CMSMenuItems.CMSMenuItemID, CMSMenuItems.CMSMenuItemType, CMSMenuItems.CMSMegaItemLayoutCode, CMSMenuItems.CMSMenuItemURL, CMSMenuItems.CMSMenuItemLinkType, CMSMenuItems.CMSRichTextPageID, CMSMenuItems.CMSFormID, CMSMenuItems.GalleryID, CMSMenuItems.CMSDynamicPageID, CMSMenuItems.DiscountID, CMSMenuItems.CategoryID, CMSMenuItems.ProductID, CMSMenuItems.CMSMenuItemImageType, CMSMenuItems.CMSMenuItemImage, CMSMenuItems.CMSMenuItemImageX AS CMSMenuItemImageWidth, CMSMenuItems.CMSMenuItemImageY AS CMSMenuItemImageHeight, CMSMenuItems.CMSSubMenuID, CMSMenuItems.CMSMenuItemParentID, CMSMenuItems.CMSMenuItemRootCategoryID, CMSMenuItemsML.CMSMenuItemName FROM CMSMenus LEFT JOIN CMSMenusML ON CMSMenus.CMSMenuID = CMSMenusML.CMSMenuID AND CMSMenusML.LanguageID = "2" LEFT JOIN CMSMenuItems ON CMSMenus.CMSMenuID = CMSMenuItems.CMSMenuID JOIN CMSMenuItemsML ON CMSMenuItems.CMSMenuItemID = CMSMenuItemsML.CMSMenuItemID AND CMSMenuItemsML.LanguageID = "2" WHERE CMSMenuIsActive AND CMSMenuItemIsActive AND CMSMenuItemName <> "" ORDER BY CMSMenuItemSort ASC
[0.001283 of 0.07377 / 73]


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]
scDal->getCmsMenuItems()    UserMenus.php[84]
miStaticDBUtil::execSelect()    Dal.php[809]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [74] SELECT CMSRichTextPageTitle FROM CMSRichTextPagesML WHERE CMSRichTextPageID="3" AND LanguageID="2" LIMIT 1
[0.000388 of 0.074158 / 74]


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]
scUtil::getMLDbValue()    FriendlyUrl.php[634]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [75] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 4 AND CustomUrlEntityID IN (3, 9, 5)
[0.000605 of 0.074763 / 75]


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[635]
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(): [76] SELECT CMSRichTextPageTitle FROM CMSRichTextPagesML WHERE CMSRichTextPageID="9" AND LanguageID="2" LIMIT 1
(simil: 2)
[0.000375 of 0.075138 / 76]


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]
scUtil::getMLDbValue()    FriendlyUrl.php[634]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [77] SELECT CategoryName FROM CategoriesML WHERE CategoryID="65" AND LanguageID="2" LIMIT 1
[0.000392 of 0.07553 / 77]


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]
scUtil::getMLDbValue()    FriendlyUrl.php[657]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


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


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]


debugQuery(): [79] SELECT CMSRichTextPageTitle FROM CMSRichTextPagesML WHERE CMSRichTextPageID="5" AND LanguageID="2" LIMIT 1
(simil: 3)
[0.000377 of 0.076568 / 79]


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]
scUtil::getMLDbValue()    FriendlyUrl.php[634]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [80] SELECT CMSFormTitle FROM CMSFormsML WHERE CMSFormID="1" AND LanguageID="2" LIMIT 1
[0.000397 of 0.076965 / 80]


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]
scUtil::getMLDbValue()    FriendlyUrl.php[638]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [81] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 5 AND CustomUrlEntityID IN (1)
(simil: 7)
[0.000566 of 0.077531 / 81]


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[639]
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(): [82] SELECT CategoryName FROM CategoriesML WHERE CategoryID="554" AND LanguageID="2" LIMIT 1
(simil: 2)
[0.000369 of 0.0779 / 82]


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]
scUtil::getMLDbValue()    FriendlyUrl.php[657]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [83] SELECT Categories.CategoryID,CategoryName FROM CategoriesML RIGHT JOIN Categories ON Categories.CategoryID=CategoriesML.CategoryID AND CategoriesML.LanguageID=2 WHERE CategoryParentID IS NULL AND CategoryStatus="1" AND CategoryDeepProductCount>"0" ORDER BY CategorySort ASC
[0.000888 of 0.078788 / 83]


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]
scUtil::getCategoriesDropdownForSearch()    UserDisplayController.php[251]
miSqlRecordset->getAllRecords()    Util.php[310]
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(): [84] SELECT TextID, TextTranslated FROM TextsTranslated WHERE TextIsTranslated = 1 AND TextOriginalHash = "3959000229" AND LanguageID = "2"
(simil: 3)
[0.000388 of 0.079176 / 84]


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]
scUtil::getCategoriesDropdownForSearch()    UserDisplayController.php[251]
_t()    Util.php[311]
scInterfaceTexts->getText()    Init.php[214]
miStaticDBUtil::execSelect()    InterfaceTexts.php[71]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [85] SELECT TextID FROM Texts WHERE TextOriginalHash = "3959000229"
(simil: 3)
[0.00034 of 0.079516 / 85]


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]
scUtil::getCategoriesDropdownForSearch()    UserDisplayController.php[251]
_t()    Util.php[311]
scInterfaceTexts->getText()    Init.php[214]
miStaticDBUtil::execSelect()    InterfaceTexts.php[74]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [86] SELECT ScriptCodePosition, ScriptCodeText FROM ScriptCodes WHERE ScriptCodeIsActive = 1
[0.000362 of 0.079878 / 86]


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]
scScriptCodeDomainObject::getEndOfHeadCode()    UserDisplayController.php[253]
scScriptCodeDomainObject::getCode()    ScriptCodeDomainObject.php[18]
miStaticDBUtil::execSelect()    ScriptCodeDomainObject.php[36]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [87] SELECT Products.*, ProductsML.ProductName, ProductsML.ProductDescription, ProductImages.ProductImageBox AS ProductImageBox,ProductImages.ProductImageBoxWidth AS ProductImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductImageBoxCdn,ProductImages.ProductImage AS ProductImage,ProductImages.ProductImageWidth AS ProductImageWidth,ProductImages.ProductImageHeight AS ProductImageHeight,ProductImages.ProductImageSize AS ProductImageSize,ProductImages.ProductImageCdn AS ProductImageCdn,ProductImagesML.ProductImageAlt,ProductImages.ProductImageBox AS ProductVariantImageBox,ProductImages.ProductImageBoxWidth AS ProductVariantImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductVariantImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductVariantImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductVariantImageBoxCdn,ProductImages.ProductImage AS ProductVariantImage,ProductImages.ProductImageWidth AS ProductVariantImageWidth,ProductImages.ProductImageHeight AS ProductVariantImageHeight,ProductImages.ProductImageSize AS ProductVariantImageSize,ProductImages.ProductImageCdn AS ProductVariantImageCdn,ProductImagesML.ProductImageAlt, ProductVariants.ProductVariantID, ProductVariants.ProductVariantCode, ProductVariants.ProductVariantWeight, ProductVariants.ProductVariantQuantity, ProductVariants.ProductVariantPrice, ProductVariants.ProductVariantAvailabilityStatus, Products.ProductID as ProductID FROM Products LEFT JOIN ProductsML ON(Products.ProductID=ProductsML.ProductID AND LanguageID = "2") LEFT JOIN ProductImages ON (Products.ProductDefaultImageID = ProductImages.ProductImageID) LEFT JOIN ProductImagesML ON (ProductImages.ProductImageID = ProductImagesML.ProductImageID AND ProductImagesML.LanguageID="2") LEFT JOIN ProductVariants ON (ProductVariants.ProductID = Products.ProductID AND ProductVariantIsDefault<>0) WHERE Products.ProductID IN ("46", "228", "230", "385") AND Products.ProductIsActive IN ("1","3")
[0.001264 of 0.081142 / 87]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scCustomerCustomProductsBox->getBoxContents()    Skins.php[521]
scCustomerCustomProductsBox->getProductsHtml()    custom_products_box.php[17]
scProductListingService->getBoxProductsSection()    custom_products_box.php[86]
miStaticDBUtil::execSelect()    ProductListingService.php[884]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [88] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 2 AND CustomUrlEntityID IN (46, 228, 230, 385)
[0.000704 of 0.081846 / 88]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scCustomerCustomProductsBox->getBoxContents()    Skins.php[521]
scCustomerCustomProductsBox->getProductsHtml()    custom_products_box.php[17]
scProductListingService->getBoxProductsSection()    custom_products_box.php[86]
scFriendlyUrl::initFriendlyUrls()    ProductListingService.php[895]
scFriendlyUrl::initProductsFriendlyUrls()    FriendlyUrl.php[192]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[793]
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(): [89] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 6 AND CustomUrlEntityID IN (0)
(simil: 8)
[0.000535 of 0.082381 / 89]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scCustomerCustomProductsBox->getBoxContents()    Skins.php[521]
scCustomerCustomProductsBox->getProductsHtml()    custom_products_box.php[17]
scProductListingService->getBoxProductsSection()    custom_products_box.php[86]
scProductListingService->getSection()    ProductListingService.php[902]
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(): [90] 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 (46, 228, 230, 385) ORDER BY OptionGroupSort, OptionSort
[0.000885 of 0.083266 / 90]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scCustomerCustomProductsBox->getBoxContents()    Skins.php[521]
scCustomerCustomProductsBox->getProductsHtml()    custom_products_box.php[17]
scProductListingService->getBoxProductsSection()    custom_products_box.php[86]
scProductListingService->getSection()    ProductListingService.php[902]
scProductListingService->getListSections()    ProductListingService.php[97]
scProductListingService->getPriceModifications()    ProductListingService.php[522]
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(): [91] 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 (46, 228, 230, 385) ORDER BY LocalOptionGroupSort,LocalOptionSort
[0.000782 of 0.084048 / 91]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scCustomerCustomProductsBox->getBoxContents()    Skins.php[521]
scCustomerCustomProductsBox->getProductsHtml()    custom_products_box.php[17]
scProductListingService->getBoxProductsSection()    custom_products_box.php[86]
scProductListingService->getSection()    ProductListingService.php[902]
scProductListingService->getListSections()    ProductListingService.php[97]
scProductListingService->getPriceModifications()    ProductListingService.php[522]
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(): [92] SELECT ProductID, AVG(ProductRatingVoteValue) AS AverageRating, COUNT(*) AS NumVotes FROM ProductRatingVotes WHERE ProductID IN ("46","228","230","385") AND ProductRatingVoteStatus = "1" GROUP BY ProductID
[0.00062 of 0.084668 / 92]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scCustomerCustomProductsBox->getBoxContents()    Skins.php[521]
scCustomerCustomProductsBox->getProductsHtml()    custom_products_box.php[17]
scProductListingService->getBoxProductsSection()    custom_products_box.php[86]
scProductListingService->getSection()    ProductListingService.php[902]
scProductListingService->getListSections()    ProductListingService.php[97]
scCustomerRatingActionsModule->getRatingsForProducts()    ProductListingService.php[544]
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(): [93] SELECT * FROM CategoriesML RIGHT JOIN Categories ON Categories.CategoryID=CategoriesML.CategoryID AND CategoriesML.LanguageID=2 WHERE CategoryStatus="1" AND CategoryDeepProductCount>"0" ORDER BY CategorySort ASC
[0.008961 of 0.093629 / 93]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scSubcategoriesWithLevelBox->getBoxContents()    Skins.php[521]
scDropdownCategoriesParser->getCategoriesRows()    subcategories_with_level_box.php[22]
miSqlRecordset->getRecords()    DropdownCategoriesParser.php[27]
miSqlRecordset->getRecordsByIndex()    SqlRecordset.php[263]
miStaticDBUtil::execSelect()    SqlRecordset.php[271]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [94] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 1 AND CustomUrlEntityID IN (1, 5, 65, 191, 246, 510, 6, 31, 37, 56, 66, 72, 99, 158, 173, 175, 183, 187, 193, 288, 314, 321, 456, 463, 491, 494, 517, 551, 558, 7, 109, 199, 320, 345, 12, 67, 71, 73, 156, 172, 177, 181, 186, 290, 312, 316, 446, 487, 489, 493, 521, 536, 559, 4, 22, 188, 245, 10, 21, 74, 159, 182, 200, 313, 332, 486, 516, 535, 560, 567, 189, 531, 541, 546, 68, 75, 157, 160, 180, 184, 190, 485, 490, 492, 524, 537, 544, 280, 545, 54, 69, 76, 100, 161, 185, 484, 515, 561, 18, 60, 51, 70, 162, 483, 488, 501, 503, 618, 311, 654, 25, 32, 53, 78, 482, 540, 620, 576, 655, 323, 458, 481, 499, 619, 8, 564, 57, 58, 254, 480, 543, 554, 479, 539, 550, 553, 478, 552, 621, 260, 477, 563, 457, 88, 476, 497, 2, 475, 496, 473, 495, 474, 471, 472, 469, 468, 467, 466, 465, 55, 29, 42, 443, 512, 50, 95, 93, 114, 117, 118, 113, 30, 616, 141, 102, 116, 86, 39, 85, 46, 104, 105, 529, 36, 528, 149, 527, 13, 20, 41, 150, 14, 63, 17, 9, 250, 251, 252, 255, 256, 257, 192, 283, 310, 34, 35, 285, 284, 286, 287, 410, 641, 328, 326, 327, 652, 324, 360, 333, 645, 334, 329, 331, 518, 342, 650, 343, 338, 341, 340, 344, 354, 352, 350, 508, 643, 77, 632, 638, 142, 498, 500, 502, 27, 110, 64, 28, 40, 630, 48, 59, 522, 61, 62, 79, 337, 89, 445, 90, 450, 91, 520, 92, 178, 97, 103, 241, 107, 525, 112, 115, 120, 533, 43, 121, 98, 122, 123, 124, 532, 125, 126, 548, 127, 128, 547, 11, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 153, 139, 154, 140, 155, 346, 565, 566, 568, 569, 570, 571, 572, 573, 575, 580, 658, 659, 289, 577, 579, 584, 660, 585, 583, 586, 601, 600, 599, 587, 588, 589, 590, 591, 598, 592, 603, 593, 594, 595, 596, 597, 602, 604, 606, 607, 609, 611, 612, 613, 614, 615, 87, 119, 622, 623, 644, 624, 253, 259, 448, 523, 628, 449, 646, 434, 633, 634, 636, 637, 455, 258, 335, 514, 336, 642, 330, 511, 625, 627, 422, 513, 530, 640, 179, 282, 19, 339, 447, 325, 96, 626, 519, 444, 649, 454, 361, 656, 581, 578, 582, 174)
[0.008814 of 0.102443 / 94]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getMiddleColumnsSection()    Skins.php[447]
scSkin->getColumn()    Skins.php[427]
scSubcategoriesWithLevelBox->getBoxContents()    Skins.php[521]
scDropdownCategoriesParser->getDropdownCategoriesHtml()    subcategories_with_level_box.php[22]
scFriendlyUrl::initFriendlyUrls()    DropdownCategoriesParser.php[37]
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(): [95] SELECT * FROM Products WHERE ProductVariantID="199"
[0.000635 of 0.103078 / 95]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductDomainObject->readByVariantId()    ProductVariant.php[146]
scSqlRecordML->read()    ProductDomainObject.php[48]
miSqlRecord->read()    SqlRecordML.php[17]
miStaticDBUtil::execSelect()    SqlRecord.php[60]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [96] SELECT * FROM ProductsML WHERE ProductID="6269" AND LanguageID IN (2)
[0.000432 of 0.10351 / 96]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductDomainObject->readByVariantId()    ProductVariant.php[146]
scSqlRecordML->read()    ProductDomainObject.php[48]
scSqlRecordML->readML()    SqlRecordML.php[18]
miStaticDBUtil::execSelect()    SqlRecordML.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [97] SELECT *, Products.ProductID as ProductID FROM Products LEFT JOIN ProductsML ON Products.ProductID = ProductsML.ProductID AND LanguageID="2" WHERE Products.ProductID="5676"
[0.000562 of 0.104072 / 97]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductSL->read()    ProductVariant.php[149]
miStaticDBUtil::execSelect()    ProductSL.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [98] SELECT * FROM Products WHERE ProductVariantID="196"
(simil: 2)
[0.000525 of 0.104597 / 98]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductDomainObject->readByVariantId()    ProductVariant.php[146]
scSqlRecordML->read()    ProductDomainObject.php[48]
miSqlRecord->read()    SqlRecordML.php[17]
miStaticDBUtil::execSelect()    SqlRecord.php[60]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [99] SELECT * FROM ProductsML WHERE ProductID="6266" AND LanguageID IN (2)
(simil: 2)
[0.000474 of 0.105071 / 99]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductDomainObject->readByVariantId()    ProductVariant.php[146]
scSqlRecordML->read()    ProductDomainObject.php[48]
scSqlRecordML->readML()    SqlRecordML.php[18]
miStaticDBUtil::execSelect()    SqlRecordML.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [100] SELECT *, Products.ProductID as ProductID FROM Products LEFT JOIN ProductsML ON Products.ProductID = ProductsML.ProductID AND LanguageID="2" WHERE Products.ProductID="5675"
(simil: 2)
[0.000554 of 0.105625 / 100]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductSL->read()    ProductVariant.php[149]
miStaticDBUtil::execSelect()    ProductSL.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [101] SELECT * FROM Products WHERE ProductVariantID="197"
(simil: 3)
[0.000534 of 0.106159 / 101]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductDomainObject->readByVariantId()    ProductVariant.php[146]
scSqlRecordML->read()    ProductDomainObject.php[48]
miSqlRecord->read()    SqlRecordML.php[17]
miStaticDBUtil::execSelect()    SqlRecord.php[60]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [102] SELECT * FROM ProductsML WHERE ProductID="6267" AND LanguageID IN (2)
(simil: 3)
[0.000397 of 0.106556 / 102]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductDomainObject->readByVariantId()    ProductVariant.php[146]
scSqlRecordML->read()    ProductDomainObject.php[48]
scSqlRecordML->readML()    SqlRecordML.php[18]
miStaticDBUtil::execSelect()    SqlRecordML.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [103] SELECT *, Products.ProductID as ProductID FROM Products LEFT JOIN ProductsML ON Products.ProductID = ProductsML.ProductID AND LanguageID="2" WHERE Products.ProductID="5674"
(simil: 3)
[0.000546 of 0.107102 / 103]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
scProductVariant->isOutOfStock()    ProductService.php[1193]
scProductVariant->getQuantityRestrictionsForCustomerGroup()    ProductVariant.php[571]
scProductVariant->getProductSL()    ProductVariant.php[563]
scProductSL->read()    ProductVariant.php[149]
miStaticDBUtil::execSelect()    ProductSL.php[27]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [104] SELECT ProductVariants.*,ProductImages.ProductImageThumb AS ProductVariantImageThumb,ProductImages.ProductImageThumbWidth AS ProductVariantImageThumbWidth,ProductImages.ProductImageThumbHeight AS ProductVariantImageThumbHeight,ProductImages.ProductImageThumbSize AS ProductVariantImageThumbSize,ProductImages.ProductImageThumbCdn AS ProductVariantImageThumbCdn,ProductImages.ProductImageBox AS ProductVariantImageBox,ProductImages.ProductImageBoxWidth AS ProductVariantImageBoxWidth,ProductImages.ProductImageBoxHeight AS ProductVariantImageBoxHeight,ProductImages.ProductImageBoxSize AS ProductVariantImageBoxSize,ProductImages.ProductImageBoxCdn AS ProductVariantImageBoxCdn,ProductImages.ProductImage AS ProductVariantImage,ProductImages.ProductImageWidth AS ProductVariantImageWidth,ProductImages.ProductImageHeight AS ProductVariantImageHeight,ProductImages.ProductImageSize AS ProductVariantImageSize,ProductImages.ProductImageCdn AS ProductVariantImageCdn,ProductImagesML.ProductImageAlt FROM ProductVariantsML RIGHT JOIN ProductVariants ON ProductVariants.ProductVariantID=ProductVariantsML.ProductVariantID AND ProductVariantsML.LanguageID=2 LEFT JOIN Products ON (Products.ProductVariantID = ProductVariants.ProductVariantID) LEFT JOIN ProductImages ON (Products.ProductDefaultImageID = ProductImages.ProductImageID) LEFT JOIN ProductImagesML ON (ProductImages.ProductImageID = ProductImagesML.ProductImageID AND ProductImagesML.LanguageID = 2) WHERE ProductVariants.ProductID IN ("5675","5674") AND ProductVariants.ProductVariantQuantity>"0" GROUP BY ProductVariants.ProductID ORDER BY ProductVariants.ProductVariantPrice ASC, ProductVariants.ProductVariantID ASC
[0.001125 of 0.108227 / 104]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductService::replaceOutOfStockVariants()    new_products_box.php[32]
miSqlRecordset->getAllRecords()    ProductService.php[1214]
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(): [105] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 2 AND CustomUrlEntityID IN (46, 228, 230, 385, 5676, 5675, 5674)
[0.000726 of 0.108953 / 105]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductListingService->getSection()    new_products_box.php[36]
scProductSL->getUrl()    ProductListingService.php[54]
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(): [106] 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 (5676, 5675, 5674) ORDER BY OptionGroupSort, OptionSort
[0.000843 of 0.109796 / 106]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductListingService->getSection()    new_products_box.php[36]
scProductListingService->getListSections()    ProductListingService.php[97]
scProductListingService->getPriceModifications()    ProductListingService.php[522]
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(): [107] 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 (5676, 5675, 5674) ORDER BY LocalOptionGroupSort,LocalOptionSort
[0.000975 of 0.110771 / 107]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductListingService->getSection()    new_products_box.php[36]
scProductListingService->getListSections()    ProductListingService.php[97]
scProductListingService->getPriceModifications()    ProductListingService.php[522]
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(): [108] SELECT ProductID, AVG(ProductRatingVoteValue) AS AverageRating, COUNT(*) AS NumVotes FROM ProductRatingVotes WHERE ProductID IN ("5676","5675","5674") AND ProductRatingVoteStatus = "1" GROUP BY ProductID
[0.000624 of 0.111395 / 108]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerNewProductsBox->getBoxContents()    Skins.php[521]
scProductListingService->getSection()    new_products_box.php[36]
scProductListingService->getListSections()    ProductListingService.php[97]
scCustomerRatingActionsModule->getRatingsForProducts()    ProductListingService.php[544]
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(): [109] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 2 AND CustomUrlEntityID IN (6127, 5447, 5961)
(simil: 2)
[0.000683 of 0.112078 / 109]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerBestSellersBox->getBoxContents()    Skins.php[521]
scCustomerBestSellersBox->getBoxForProducts()    bestsellers_box.php[36]
scProductListingService->getSection()    bestsellers_box.php[250]
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(): [110] 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 (6127, 5447, 5961) ORDER BY OptionGroupSort, OptionSort
(simil: 2)
[0.00085 of 0.112928 / 110]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerBestSellersBox->getBoxContents()    Skins.php[521]
scCustomerBestSellersBox->getBoxForProducts()    bestsellers_box.php[36]
scProductListingService->getSection()    bestsellers_box.php[250]
scProductListingService->getListSections()    ProductListingService.php[97]
scProductListingService->getPriceModifications()    ProductListingService.php[522]
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(): [111] 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 (6127, 5447, 5961) ORDER BY LocalOptionGroupSort,LocalOptionSort
(simil: 2)
[0.000737 of 0.113665 / 111]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerBestSellersBox->getBoxContents()    Skins.php[521]
scCustomerBestSellersBox->getBoxForProducts()    bestsellers_box.php[36]
scProductListingService->getSection()    bestsellers_box.php[250]
scProductListingService->getListSections()    ProductListingService.php[97]
scProductListingService->getPriceModifications()    ProductListingService.php[522]
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(): [112] SELECT ProductID, AVG(ProductRatingVoteValue) AS AverageRating, COUNT(*) AS NumVotes FROM ProductRatingVotes WHERE ProductID IN ("6127","5447","5961") AND ProductRatingVoteStatus = "1" GROUP BY ProductID
(simil: 2)
[0.000653 of 0.114318 / 112]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerBestSellersBox->getBoxContents()    Skins.php[521]
scCustomerBestSellersBox->getBoxForProducts()    bestsellers_box.php[36]
scProductListingService->getSection()    bestsellers_box.php[250]
scProductListingService->getListSections()    ProductListingService.php[97]
scCustomerRatingActionsModule->getRatingsForProducts()    ProductListingService.php[544]
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(): [113] SELECT BrandName, BrandImage, BrandImageCdn, Brands.BrandID AS BrandID, BrandImageWidth, BrandImageHeight FROM Brands LEFT JOIN BrandsML USING(BrandID) WHERE LanguageID = "2" ORDER BY BrandSort ASC LIMIT 0, 7
[0.000702 of 0.11502 / 113]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerBrandsBox->getBoxContents()    Skins.php[521]
miStaticDBUtil::execSelect()    brands_box.php[73]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [114] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 6 AND CustomUrlEntityID IN (1, 2, 3, 4, 5, 6)
[0.000739 of 0.115759 / 114]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scSkin->getMainAreaHtml()    UserDisplayController.php[516]
scSkin->getBottomColumnsSection()    Skins.php[448]
scSkin->getColumn()    Skins.php[399]
scCustomerBrandsBox->getBoxContents()    Skins.php[521]
scTable->getSection()    brands_box.php[84]
scBrandsBoxTable->addUiElements()    Table.php[26]
scFriendlyUrl::initFriendlyUrls()    brands_box.php[15]
scFriendlyUrl::initBrandsFriendlyUrls()    FriendlyUrl.php[171]
scFriendlyUrl::getFriendlyUrl()    FriendlyUrl.php[736]
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(): [115] SELECT CountryName FROM CountriesML WHERE CountryID="34" AND LanguageID="2" LIMIT 1
[0.000405 of 0.116164 / 115]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getFooter()    UserDisplayController.php[519]
scCountry::getCountryName()    UserDisplayController.php[433]
scUtil::getMLDbValue()    Country.php[20]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [116] SELECT StateName FROM StatesML WHERE StateID="77" AND LanguageID="2" LIMIT 1
[0.000391 of 0.116555 / 116]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getFooter()    UserDisplayController.php[519]
scCountry::getStateName()    UserDisplayController.php[435]
scUtil::getMLDbValue()    Country.php[59]
miStaticDBUtil::execSelect()    Util.php[31]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [117] SELECT NLLists.NLListID FROM NLNewsletters LEFT JOIN NLLists ON NLNewsletters.NLListID = NLLists.NLListID WHERE NLLists.NLListInFooter = 1 AND NLNewsletters.NewsletterIsActive = 1 GROUP BY NLLists.NLListID
[0.000591 of 0.117146 / 117]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getFooter()    UserDisplayController.php[519]
scUserDisplayController->getFooterNewsletterSection()    UserDisplayController.php[449]
miStaticDBUtil::execSelect()    UserDisplayController.php[626]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [118] SELECT CMSRichTextPages.CMSRichTextPageID, CMSRichTextPages.CMSRichTextPageUrl, CMSRichTextPagesML.CMSRichTextPageTitle FROM CMSRichTextPagesML RIGHT JOIN CMSRichTextPages ON CMSRichTextPages.CMSRichTextPageID = CMSRichTextPagesML.CMSRichTextPageID AND CMSRichTextPagesML.LanguageID = "2" WHERE CMSRichTextPages.CMSRichTextPageIsActive = "1" AND CMSRichTextPages.CMSRichTextPageID = "7"
[0.000468 of 0.117614 / 118]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getFooter()    UserDisplayController.php[519]
scUserDisplayController->getFooterGDPRPolicyLinkSeciton()    UserDisplayController.php[449]
scGdpr->getGdprPolicyPageUrl()    UserDisplayController.php[791]
miStaticDBUtil::execSelect()    Gdpr.php[199]
miDBUtilImpl->execSelect()    StaticDBUtil.php[40]
miDBUtilImpl->execSQL()    DBUtilImpl.php[162]
miDBUtilImpl->debugQuery()    DBUtilImpl.php[63]


debugQuery(): [119] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 4 AND CustomUrlEntityID IN (7)
(simil: 9)
[0.000524 of 0.118138 / 119]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getFooter()    UserDisplayController.php[519]
scUserDisplayController->getFooterGDPRPolicyLinkSeciton()    UserDisplayController.php[449]
scGdpr->getGdprPolicyPageUrl()    UserDisplayController.php[791]
scFriendlyUrl::getFriendlyUrl()    Gdpr.php[203]
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(): [120] SELECT CustomUrlEntityID, CustomUrlText FROM CustomUrls INNER JOIN CustomUrlsML USING(CustomUrlID) WHERE CustomUrlIsCurrent AND LanguageID = 2 AND CustomUrlEntityCode = 17 AND CustomUrlEntityID IN (0)
(simil: 10)
[0.000529 of 0.118667 / 120]


scCustomUrlResolver->resolve()    custom_url.php[12]
require()    custom_url.php[110]
scUserDisplayController->dispatchAndShow()    categories.php[206]
scUserDisplayController->showPage()    UserDisplayController.php[551]
scUserDisplayController->getFooter()    UserDisplayController.php[519]
scFriendlyUrl::getFriendlyUrl()    UserDisplayController.php[450]
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]
Батерия за GPS навигация

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

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


Total MySQL time: 0.118667
Total MySQL queires: 120