scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductSL->isOutOfStock() ProductService.php[438]
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(): [21] 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 (3651,3651,3651,3651)) [0.00081 of 0.013353 / 21]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductSL->getBrand() ProductService.php[489]
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(): [22] SELECT ProductImages.ProductImage AS ProductImage,ProductImages.ProductImageWidth AS ProductImageWidth,ProductImages.ProductImageHeight AS ProductImageHeight,ProductImages.ProductImageSize AS ProductImageSize,ProductImages.ProductImageCdn AS ProductImageCdn,ProductImages.ProductImageLarge AS ProductImageLarge,ProductImages.ProductImageLargeWidth AS ProductImageLargeWidth,ProductImages.ProductImageLargeHeight AS ProductImageLargeHeight,ProductImages.ProductImageLargeSize AS ProductImageLargeSize,ProductImages.ProductImageLargeCdn AS ProductImageLargeCdn,ProductImages.ProductImageThumb AS ProductImageThumb,ProductImages.ProductImageThumbWidth AS ProductImageThumbWidth,ProductImages.ProductImageThumbHeight AS ProductImageThumbHeight,ProductImages.ProductImageThumbSize AS ProductImageThumbSize,ProductImages.ProductImageThumbCdn AS ProductImageThumbCdn,ProductImagesML.ProductImageAlt,ProductImages.ProductImageID,ProductImages.ProductImageIsDefault FROM ProductImagesML RIGHT JOIN ProductImages ON ProductImages.ProductImageID=ProductImagesML.ProductImageID AND ProductImagesML.LanguageID=2 WHERE ProductID="3651" AND ProductImageFeaturedStyle="0" ORDER BY ProductImageIsDefault DESC, ProductImageSort ASC [0.000723 of 0.014076 / 22]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductService::addImagesSections() ProductService.php[544]
scProductSL->getImages() ProductService.php[975]
miSqlRecordset->getAllRecords() ProductSL.php[358]
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 ProductImages.ProductImage AS ProductImage,ProductImages.ProductImageWidth AS ProductImageWidth,ProductImages.ProductImageHeight AS ProductImageHeight,ProductImages.ProductImageSize AS ProductImageSize,ProductImages.ProductImageCdn AS ProductImageCdn,ProductImages.ProductImageLarge AS ProductImageLarge,ProductImages.ProductImageLargeWidth AS ProductImageLargeWidth,ProductImages.ProductImageLargeHeight AS ProductImageLargeHeight,ProductImages.ProductImageLargeSize AS ProductImageLargeSize,ProductImages.ProductImageLargeCdn AS ProductImageLargeCdn,ProductImages.ProductImageThumb AS ProductImageThumb,ProductImages.ProductImageThumbWidth AS ProductImageThumbWidth,ProductImages.ProductImageThumbHeight AS ProductImageThumbHeight,ProductImages.ProductImageThumbSize AS ProductImageThumbSize,ProductImages.ProductImageThumbCdn AS ProductImageThumbCdn,ProductImagesML.ProductImageAlt,Products.ProductVariantID,ProductVariants.ProductVariantImageOptionsJson,ProductImages.ProductImageID,ProductImages.ProductImageIsDefault FROM ProductImagesML RIGHT JOIN ProductImages ON ProductImages.ProductImageID=ProductImagesML.ProductImageID AND ProductImagesML.LanguageID=2 LEFT JOIN Products USING(ProductID) LEFT JOIN ProductVariants USING(ProductVariantID) WHERE ProductParentID="3651" AND ProductImageFeaturedStyle="0" ORDER BY ProductVariantIsDefault DESC, ProductCode ASC, ProductImageIsDefault DESC, ProductImageSort ASC [0.005371 of 0.019447 / 23]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductService::addImagesSections() ProductService.php[544]
scProductSL->getVariantsImages() ProductService.php[976]
miSqlRecordset->getAllRecords() ProductSL.php[402]
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
TagsML.TagID,
TagsML.TagName
FROM ProductTags
LEFT JOIN TagsML ON (TagsML.TagID = ProductTags.TagID AND TagsML.LanguageId = "2")
WHERE ProductTags.ProductID = "3651"
ORDER BY TagsML.TagName [0.000553 of 0.02 / 24]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductService::getProductTagsSection() ProductService.php[560]
miStaticDBUtil::execSelect() ProductService.php[1776]
miDBUtilImpl->execSelect() StaticDBUtil.php[40]
miDBUtilImpl->execSQL() DBUtilImpl.php[162]
miDBUtilImpl->debugQuery() DBUtilImpl.php[63] debugQuery(): [25] SELECT *,ProductAttributeValues.ProductAttributeValueID FROM ProductAttributeValues LEFT JOIN ProductAttributeValuesML ON(ProductAttributeValues.ProductAttributeValueID=ProductAttributeValuesML.ProductAttributeValueID AND LanguageID=2) WHERE ProductID="3651" [0.000552 of 0.020552 / 25]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductService::getProductAttributes() ProductService.php[595]
scProductAttributes->getProductAttributeValues() ProductService.php[807]
miSqlRecordset->getAllRecords() ProductAttributes.php[418]
miSqlRecordset->getRecordsByIndex() SqlRecordset.php[275]
miStaticDBUtil::execSelect() SqlRecordset.php[271]
miDBUtilImpl->execSelect() StaticDBUtil.php[40]
miDBUtilImpl->execSQL() DBUtilImpl.php[162]
miDBUtilImpl->debugQuery() DBUtilImpl.php[63] debugQuery(): [26] SELECT DISTINCTROW ProductClassID, AttributeID
FROM ProductClassXAttributes
JOIN Products USING(ProductClassID)
WHERE ProductID IN(5676,5675,5674,6127,5447,5961,46,228,230,385,3651,3651,3651,3651)
ORDER BY ProductClassXAttributeSort [0.000668 of 0.02122 / 26]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductService::getProductAttributes() ProductService.php[595]
scDal->getAttributes() ProductService.php[809]
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(): [27] SELECT * FROM ProductFiles LEFT JOIN ProductFilesML ON (ProductFiles.PRoductFileID = ProductFilesML.PRoductFileID AND LanguageID="2") WHERE ProductID = "3651" [0.000513 of 0.021733 / 27]
scCustomUrlResolver->resolve() custom_url.php[12]
require() custom_url.php[110]
scUserDisplayController->dispatchAndShow() product.php[339]
miDispatcher->process() UserDisplayController.php[550]
scShowProductAction->doAction() Dispatcher.php[37]
scProductService::getSingleProductSection() product.php[57]
scProductService::getProductFilesSection() ProductService.php[610]
miStaticDBUtil::execSelect() ProductService.php[1320]
miDBUtilImpl->execSelect() StaticDBUtil.php[40]
miDBUtilImpl->execSQL() DBUtilImpl.php[162]
miDBUtilImpl->debugQuery() DBUtilImpl.php[63] debugQuery(): [28] SELECT * FROM ProductVideos WHERE ProductID="3651" ORDER BY ProductVideoSort ASC [0.000429 of 0.022162 / 28]