Сетове

POSTVAR

key

value

GETVAR

key

value

Data Base - dentallc_arabicscentsbgnew
Start - 23:33:14.35
End - 23:33:22.489
Duration - 8.455
Memory Usage - 1 158,055KB
Count queries - 103
Total queries time - 8,441
Fastest query - 0,000
Slowest query - 8,174
Slowest query stringSELECT m.idProduct, m.Num, m.CImage, m.OptRequired, m.State, m.AddDate , m.idTaxClass, m.Price, m.PriceTax , sp.Price AS SPrice, sp.PriceTax AS SPriceTax, sp.Rate AS SRate , dp.Price AS DPrice, dp.PriceTax AS DPriceTax , IF (m.MaxQuantity <> 0, LEAST(m.MaxQuantity, m.Quantity), m.Quantity) AS Quantity, IF (m.MinQuantity, m.MinQuantity, 1) AS MinQuantity , ml.Name, ml.Description, ml.URLAlias , mols.Name AS StateName , m.idManufacturer, sm.CImage as ManuImage, mlm.Name AS ManuName, mlm.URLAlias AS MURLAlias , m.idCategory, cl.Name as CName, cl.URLAlias as CURLAlias , 'new' AS opt FROM mod_StoreProduct m INNER JOIN mod_StoreLang ml ON (m.idProduct = ml.idProduct) AND (ml.idLanguage = 'bg') INNER JOIN CategoryLang cl ON (cl.idCategory = m.idCategory) AND (cl.idLanguage = 'bg') LEFT JOIN mod_StoreOtherLang mols ON (mols.Source = 'state') AND (mols.idRec = m.idState) AND (mols.idLanguage = 'bg') LEFT JOIN ( SELECT idProduct, Price, PriceTax, Rate, EndDate FROM v_StoreDiscount WHERE (Special = 1) AND (idUGroup IN (COALESCE('0', 0), 0)) ) AS sp ON (sp.idProduct = m.idProduct) LEFT JOIN ( SELECT idProduct, Price, PriceTax, Rate, EndDate FROM v_StoreDiscount WHERE (Special = 0) AND (Quantity = 1) AND (idUGroup IN (COALESCE('0', 0), 0)) ) AS dp ON (dp.idProduct = m.idProduct) LEFT JOIN mod_StoreManufacturer AS sm ON (sm.idManufacturer = m.idManufacturer) LEFT JOIN mod_StoreMLang AS mlm ON (mlm.idManufacturer = m.idManufacturer) AND (mlm.idLanguage = 'bg') WHERE (1) and (m.State & '435') ORDER BY m.AddDate DESC LIMIT 10