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 (554,554,554,554)) [0.000938 of 0.016228 / 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="554" AND ProductImageFeaturedStyle="0" ORDER BY ProductImageIsDefault DESC, ProductImageSort ASC [0.000865 of 0.017093 / 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="554" AND ProductImageFeaturedStyle="0" ORDER BY ProductVariantIsDefault DESC, ProductCode ASC, ProductImageIsDefault DESC, ProductImageSort ASC [0.005251 of 0.022344 / 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 = "554"
ORDER BY TagsML.TagName [0.000683 of 0.023027 / 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="554" [0.000921 of 0.023948 / 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 ProductAttributeValueID,AttributeMultiValue,AttributeOptionML FROM ProductAttributeMultiValues INNER JOIN AttributeOptions ON ProductAttributeMultiValues.AttributeMultiValue = AttributeOptions.AttributeOptionID LEFT JOIN AttributeOptionsML USING(AttributeOptionID) WHERE ProductAttributeValueID IN ("1503","1504","1505","1506","1509","1508","1507","6621","6622","6623","6624","6625","6626","6627","6628","6629","6630","6631") AND LanguageID IN ("2") ORDER BY AttributeOptionSort ASC [0.000909 of 0.024857 / 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]
scProductAttributes->getProductAttributeValues() ProductService.php[807]
miSqlRecordset->getAllRecords() ProductAttributes.php[431]
miSqlRecordset->getRecordsByIndex() SqlRecordset.php[275]
miStaticDBUtil::execSelect() SqlRecordset.php[271]
miDBUtilImpl->execSelect() StaticDBUtil.php[40]
miDBUtilImpl->execSQL() DBUtilImpl.php[162]
miDBUtilImpl->debugQuery() DBUtilImpl.php[63] debugQuery(): [27] SELECT DISTINCTROW ProductClassID, AttributeID
FROM ProductClassXAttributes
JOIN Products USING(ProductClassID)
WHERE ProductID IN(5676,5675,5674,6127,5447,5961,46,228,230,385,554,554,554,554)
ORDER BY ProductClassXAttributeSort [0.000791 of 0.025648 / 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::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(): [28] SELECT * FROM ProductFiles LEFT JOIN ProductFilesML ON (ProductFiles.PRoductFileID = ProductFilesML.PRoductFileID AND LanguageID="2") WHERE ProductID = "554" [0.000625 of 0.026273 / 28]
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(): [29] SELECT * FROM ProductVideos WHERE ProductID="554" ORDER BY ProductVideoSort ASC [0.000529 of 0.026802 / 29]