Electrocasnice

Aspiratoare

Aspiratoare

Fiare și Stații de călcat

Fiare și Stații de călcat

Purificatoare de aer

Purificatoare de aer

Accesorii aspiratoare

Accesorii aspiratoare

Accesorii fiare de călcat

Accesorii fiare de călcat

Accesorii purificatoare

Accesorii purificatoare

Long queries

Profiling Summary Report (Time: 0.18100s, Memory: 4,473KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.18105s, Memory: 4,473KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 13 0.00132 0.00010 0.00005 0.00014
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 13 0.00114 0.00009 0.00005 0.00013
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='409') LIMIT 1) 2 0.00029 0.00014 0.00007 0.00021
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='52') 2 0.00020 0.00010 0.00009 0.00011
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='40') 2 0.00017 0.00009 0.00008 0.00009
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='39') 2 0.00016 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='42') 2 0.00012 0.00006 0.00006 0.00007
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='82') 2 0.00011 0.00006 0.00005 0.00006
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='41') 2 0.00010 0.00005 0.00004 0.00007
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='409') 2 0.00009 0.00005 0.00005 0.00005

Classic summary

Profiling Summary Report (Time: 0.18119s, Memory: 4,473KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp8 AND t.Incoming=:ycp9 AND t.IsMarketable=:ycp10) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='41', :hash='%;41;%', :ycp8=1, :ycp9=0, :ycp10=1, :delivered=16) 1 0.02850 0.02850 0.02850 0.02850
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp11 AND t.Incoming=:ycp12 AND t.IsMarketable=:ycp13) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='41', :hash='%;41;%', :ycp11=1, :ycp12=0, :ycp13=1, :delivered=16) 1 0.02506 0.02506 0.02506 0.02506
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp2 AND t.Incoming=:ycp3 AND t.IsMarketable=:ycp4) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='39', :hash='%;39;%', :ycp2=1, :ycp3=0, :ycp4=1, :delivered=16) 1 0.01809 0.01809 0.01809 0.01809
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp5 AND t.Incoming=:ycp6 AND t.IsMarketable=:ycp7) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='39', :hash='%;39;%', :ycp5=1, :ycp6=0, :ycp7=1, :delivered=16) 1 0.01627 0.01627 0.01627 0.01627
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp14 AND t.Incoming=:ycp15 AND t.IsMarketable=:ycp16) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='52', :hash='%;52;%', :ycp14=1, :ycp15=0, :ycp16=1, :delivered=16) 1 0.00436 0.00436 0.00436 0.00436
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp17 AND t.Incoming=:ycp18 AND t.IsMarketable=:ycp19) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='52', :hash='%;52;%', :ycp17=1, :ycp18=0, :ycp19=1, :delivered=16) 1 0.00400 0.00400 0.00400 0.00400
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp20 AND t.Incoming=:ycp21 AND t.IsMarketable=:ycp22) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='40', :hash='%;40;%', :ycp20=1, :ycp21=0, :ycp22=1, :delivered=16) 1 0.00377 0.00377 0.00377 0.00377
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp23 AND t.Incoming=:ycp24 AND t.IsMarketable=:ycp25) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='40', :hash='%;40;%', :ycp23=1, :ycp24=0, :ycp25=1, :delivered=16) 1 0.00352 0.00352 0.00352 0.00352
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp29 AND t.Incoming=:ycp30 AND t.IsMarketable=:ycp31) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='42', :hash='%;42;%', :ycp29=1, :ycp30=0, :ycp31=1, :delivered=16) 1 0.00304 0.00304 0.00304 0.00304
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp26 AND t.Incoming=:ycp27 AND t.IsMarketable=:ycp28) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='42', :hash='%;42;%', :ycp26=1, :ycp27=0, :ycp28=1, :delivered=16) 1 0.00296 0.00296 0.00296 0.00296
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp32 AND t.Incoming=:ycp33 AND t.IsMarketable=:ycp34) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp32=1, :ycp33=0, :ycp34=1, :delivered=16) 1 0.00217 0.00217 0.00217 0.00217
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp38 AND t.Incoming=:ycp39 AND t.IsMarketable=:ycp40) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp38=1, :ycp39=0, :ycp40=1, :delivered=16) 1 0.00215 0.00215 0.00215 0.00215
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 13 0.00132 0.00010 0.00005 0.00014
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 13 0.00114 0.00009 0.00005 0.00013
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Article`) 1 0.00103 0.00103 0.00103 0.00103
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `DictionaryDetail`) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Dictionary`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1664') LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1325') LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='327') LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2028') 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2032') LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1325') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1579854882) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `Article`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='409') LIMIT 1) 2 0.00029 0.00014 0.00007 0.00021
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='344') LIMIT 1) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='327') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1579854882, :id='frdtuitargjj11b3kouls55sgl') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2041') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='327') 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1325') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1664') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1338') LIMIT 1) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='52') 2 0.00020 0.00010 0.00009 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2028') 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1664') 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2041') 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2032') 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='40') 2 0.00017 0.00009 0.00008 0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `DictionaryDetail`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='39') 2 0.00016 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1337') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query( SELECT * FROM Category as t WHERE t.ParentId = :parent AND t.VisibleOnSite = 1 AND t.Enabled = 1 ORDER BY t.HasProducts DESC, t.Priority ASC, CASE WHEN (SELECT COUNT(Id) FROM Category WHERE ParentId = t.Id) > 0 THEN 1 ELSE 0 END. Bound with parent='15') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2041') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2045') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT c.*, parent.Code as parentCode, parent.Id as parentId, parent.Name as parentName FROM Category c LEFT JOIN Category as parent ON (parent.Id = c.ParentId) WHERE c.Id=:category AND c.Enabled = 1. Bound with category='15') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='15') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='42') 2 0.00012 0.00006 0.00006 0.00007
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2032') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1337') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1338') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2028') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='344') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='5') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='82') 2 0.00011 0.00006 0.00005 0.00006
system.db.CDbCommand.query( SELECT t.* FROM Manufacturer as t LEFT JOIN Article a ON (t.Id = a.ManufacturerId) LEFT JOIN Category c ON (c.Id = a.ArticleClassId) WHERE c.ParentsIdHash LIKE '%;15;%' AND a.VisibleOnSite = 1 AND t.Name != "IMPORT_NULL" AND t.Name != '1Producator Nebagat' AND t.Enabled = 1 GROUP BY t.Id ORDER BY t.Name) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='409') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `Dictionary`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='41') 2 0.00010 0.00005 0.00004 0.00007
system.db.CDbCommand.query(SELECT Id, Enabled, HasProducts, MainSpecificationId FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Link = :link AND VisibleOnSite = 1) LIMIT 1. Bound with :link='Electrocasnice-Restul-casei') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT 1 FROM `Category` `t` WHERE (`t`.Enabled=1) AND (ParentId = :selfId) LIMIT 1. Bound with :selfId='15') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2045') LIMIT 1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='409') 2 0.00009 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='5') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='344') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1338') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id, Value FROM `DictionaryDetail` `t` WHERE ((`t`.Enabled=1) AND (DictionaryId=:ycp1)) AND (Code = :code) LIMIT 1. Bound with :ycp1='26', :code='CATEGORY_META_DESCRIPTION') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp35 AND t.Incoming=:ycp36 AND t.IsMarketable=:ycp37) GROUP BY t.Id LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp35=1, :ycp36=0, :ycp37=1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp41 AND t.Incoming=:ycp42 AND t.IsMarketable=:ycp43) GROUP BY t.Id LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp41=1, :ycp42=0, :ycp43=1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2045') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id, Value FROM `DictionaryDetail` `t` WHERE ((`t`.Enabled=1) AND (DictionaryId=:ycp0)) AND (Code = :code) LIMIT 1. Bound with :ycp0='26', :code='category_title') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1337') 1 0.00004 0.00004 0.00004 0.00004

Long queries

Profiling Summary Report (Time: 0.18319s, Memory: 4,474KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.18323s, Memory: 4,474KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 13 0.00132 0.00010 0.00005 0.00014
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 13 0.00114 0.00009 0.00005 0.00013
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='409') LIMIT 1) 2 0.00029 0.00014 0.00007 0.00021
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='52') 2 0.00020 0.00010 0.00009 0.00011
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='40') 2 0.00017 0.00009 0.00008 0.00009
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='39') 2 0.00016 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='42') 2 0.00012 0.00006 0.00006 0.00007
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='82') 2 0.00011 0.00006 0.00005 0.00006
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='41') 2 0.00010 0.00005 0.00004 0.00007
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='409') 2 0.00009 0.00005 0.00005 0.00005

Classic summary

Profiling Summary Report (Time: 0.18334s, Memory: 4,474KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp8 AND t.Incoming=:ycp9 AND t.IsMarketable=:ycp10) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='41', :hash='%;41;%', :ycp8=1, :ycp9=0, :ycp10=1, :delivered=16) 1 0.02850 0.02850 0.02850 0.02850
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp11 AND t.Incoming=:ycp12 AND t.IsMarketable=:ycp13) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='41', :hash='%;41;%', :ycp11=1, :ycp12=0, :ycp13=1, :delivered=16) 1 0.02506 0.02506 0.02506 0.02506
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp2 AND t.Incoming=:ycp3 AND t.IsMarketable=:ycp4) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='39', :hash='%;39;%', :ycp2=1, :ycp3=0, :ycp4=1, :delivered=16) 1 0.01809 0.01809 0.01809 0.01809
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp5 AND t.Incoming=:ycp6 AND t.IsMarketable=:ycp7) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='39', :hash='%;39;%', :ycp5=1, :ycp6=0, :ycp7=1, :delivered=16) 1 0.01627 0.01627 0.01627 0.01627
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp14 AND t.Incoming=:ycp15 AND t.IsMarketable=:ycp16) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='52', :hash='%;52;%', :ycp14=1, :ycp15=0, :ycp16=1, :delivered=16) 1 0.00436 0.00436 0.00436 0.00436
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp17 AND t.Incoming=:ycp18 AND t.IsMarketable=:ycp19) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='52', :hash='%;52;%', :ycp17=1, :ycp18=0, :ycp19=1, :delivered=16) 1 0.00400 0.00400 0.00400 0.00400
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp20 AND t.Incoming=:ycp21 AND t.IsMarketable=:ycp22) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='40', :hash='%;40;%', :ycp20=1, :ycp21=0, :ycp22=1, :delivered=16) 1 0.00377 0.00377 0.00377 0.00377
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp23 AND t.Incoming=:ycp24 AND t.IsMarketable=:ycp25) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='40', :hash='%;40;%', :ycp23=1, :ycp24=0, :ycp25=1, :delivered=16) 1 0.00352 0.00352 0.00352 0.00352
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp29 AND t.Incoming=:ycp30 AND t.IsMarketable=:ycp31) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='42', :hash='%;42;%', :ycp29=1, :ycp30=0, :ycp31=1, :delivered=16) 1 0.00304 0.00304 0.00304 0.00304
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp26 AND t.Incoming=:ycp27 AND t.IsMarketable=:ycp28) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='42', :hash='%;42;%', :ycp26=1, :ycp27=0, :ycp28=1, :delivered=16) 1 0.00296 0.00296 0.00296 0.00296
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp32 AND t.Incoming=:ycp33 AND t.IsMarketable=:ycp34) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp32=1, :ycp33=0, :ycp34=1, :delivered=16) 1 0.00217 0.00217 0.00217 0.00217
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id LEFT JOIN DocumentDetail dd ON (dd.ArticleId = t.Id) LEFT JOIN Document d ON (d.Id = dd.DocumentId AND d.Date BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW() AND d.DocumentStateId = :delivered) LEFT JOIN ArticleXPromoTitle axp ON (axp.ArticleId = t.Id) WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp38 AND t.Incoming=:ycp39 AND t.IsMarketable=:ycp40) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp38=1, :ycp39=0, :ycp40=1, :delivered=16) 1 0.00215 0.00215 0.00215 0.00215
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 13 0.00132 0.00010 0.00005 0.00014
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 13 0.00114 0.00009 0.00005 0.00013
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Article`) 1 0.00103 0.00103 0.00103 0.00103
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `DictionaryDetail`) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Dictionary`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1664') LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1325') LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='327') LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2028') 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2032') LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1325') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1579854882) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `Article`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='409') LIMIT 1) 2 0.00029 0.00014 0.00007 0.00021
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='344') LIMIT 1) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='327') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1579854882, :id='frdtuitargjj11b3kouls55sgl') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2041') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='327') 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1325') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1664') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1338') LIMIT 1) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='52') 2 0.00020 0.00010 0.00009 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2028') 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1664') 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2041') 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2032') 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='40') 2 0.00017 0.00009 0.00008 0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `DictionaryDetail`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='39') 2 0.00016 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1337') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query( SELECT * FROM Category as t WHERE t.ParentId = :parent AND t.VisibleOnSite = 1 AND t.Enabled = 1 ORDER BY t.HasProducts DESC, t.Priority ASC, CASE WHEN (SELECT COUNT(Id) FROM Category WHERE ParentId = t.Id) > 0 THEN 1 ELSE 0 END. Bound with parent='15') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2041') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2045') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT c.*, parent.Code as parentCode, parent.Id as parentId, parent.Name as parentName FROM Category c LEFT JOIN Category as parent ON (parent.Id = c.ParentId) WHERE c.Id=:category AND c.Enabled = 1. Bound with category='15') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='15') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='42') 2 0.00012 0.00006 0.00006 0.00007
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2032') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1337') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1338') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2028') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='344') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='5') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='82') 2 0.00011 0.00006 0.00005 0.00006
system.db.CDbCommand.query( SELECT t.* FROM Manufacturer as t LEFT JOIN Article a ON (t.Id = a.ManufacturerId) LEFT JOIN Category c ON (c.Id = a.ArticleClassId) WHERE c.ParentsIdHash LIKE '%;15;%' AND a.VisibleOnSite = 1 AND t.Name != "IMPORT_NULL" AND t.Name != '1Producator Nebagat' AND t.Enabled = 1 GROUP BY t.Id ORDER BY t.Name) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='409') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `Dictionary`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='41') 2 0.00010 0.00005 0.00004 0.00007
system.db.CDbCommand.query(SELECT Id, Enabled, HasProducts, MainSpecificationId FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Link = :link AND VisibleOnSite = 1) LIMIT 1. Bound with :link='Electrocasnice-Restul-casei') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT 1 FROM `Category` `t` WHERE (`t`.Enabled=1) AND (ParentId = :selfId) LIMIT 1. Bound with :selfId='15') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2045') LIMIT 1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='409') 2 0.00009 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='5') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='344') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1338') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id, Value FROM `DictionaryDetail` `t` WHERE ((`t`.Enabled=1) AND (DictionaryId=:ycp1)) AND (Code = :code) LIMIT 1. Bound with :ycp1='26', :code='CATEGORY_META_DESCRIPTION') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp35 AND t.Incoming=:ycp36 AND t.IsMarketable=:ycp37) GROUP BY t.Id LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp35=1, :ycp36=0, :ycp37=1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT t.Id FROM `Article` `t` INNER JOIN DocumentFile df ON df.ArticleId = t.Id WHERE (t.ArticleClassId = :catId OR t.ArticleClassHash LIKE :hash) AND (t.VisibleOnSite=:ycp41 AND t.Incoming=:ycp42 AND t.IsMarketable=:ycp43) GROUP BY t.Id LIMIT 10. Bound with :catId='82', :hash='%;82;%', :ycp41=1, :ycp42=0, :ycp43=1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2045') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id, Value FROM `DictionaryDetail` `t` WHERE ((`t`.Enabled=1) AND (DictionaryId=:ycp0)) AND (Code = :code) LIMIT 1. Bound with :ycp0='26', :code='category_title') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1337') 1 0.00004 0.00004 0.00004 0.00004