Electrocasnice

Storcătoare

Storcătoare

Blendere

Blendere

Roboți de bucătărie

Roboți de bucătărie

Mixere

Mixere

Mașini de tocat

Mașini de tocat

Moară de cereale

Moară de cereale

Prăjitoare de pâine

Prăjitoare de pâine

Aparate de vidat și acc.

Aparate de vidat și acc.

Presă de ulei

Presă de ulei

Fierbătoare

Fierbătoare

Pahare, Căni, Sticle

Pahare, Căni, Sticle

Forme înghețată

Forme înghețată

Accesorii storcătoare

Accesorii storcătoare

Accesorii blendere

Accesorii blendere

Piese blendere

Piese blendere

Aparate de gătit

Aparate de gătit

Long queries

Profiling Summary Report (Time: 0.24944s, Memory: 7,125KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.24947s, Memory: 7,125KB)
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') 33 0.00277 0.00008 0.00005 0.00013
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 33 0.00265 0.00008 0.00004 0.00014
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1292') LIMIT 1) 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='44') 2 0.00019 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1949') LIMIT 1) 2 0.00018 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='22') 2 0.00018 0.00009 0.00008 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='50') 2 0.00017 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1142') LIMIT 1) 2 0.00016 0.00008 0.00006 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='51') 2 0.00015 0.00008 0.00007 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='21') 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1269') LIMIT 1) 2 0.00015 0.00007 0.00006 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='55') 2 0.00014 0.00007 0.00007 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='36') 2 0.00013 0.00007 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='1142') 2 0.00013 0.00006 0.00003 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='54') 2 0.00013 0.00006 0.00005 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='56') 2 0.00013 0.00006 0.00004 0.00009
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1949') 2 0.00012 0.00006 0.00005 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='67') 2 0.00010 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='23') 2 0.00010 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1292') 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1269') 2 0.00008 0.00004 0.00003 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='25') 2 0.00008 0.00004 0.00003 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='43') 2 0.00007 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='53') 2 0.00007 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='66') 2 0.00006 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='75') 2 0.00006 0.00003 0.00003 0.00003

Classic summary

Profiling Summary Report (Time: 0.24960s, Memory: 7,125KB)
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=:ycp68 AND t.Incoming=:ycp69 AND t.IsMarketable=:ycp70) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='23', :hash='%;23;%', :ycp68=1, :ycp69=0, :ycp70=1, :delivered=16) 1 0.01413 0.01413 0.01413 0.01413
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=:ycp71 AND t.Incoming=:ycp72 AND t.IsMarketable=:ycp73) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='23', :hash='%;23;%', :ycp71=1, :ycp72=0, :ycp73=1, :delivered=16) 1 0.01369 0.01369 0.01369 0.01369
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='21', :hash='%;21;%', :ycp2=1, :ycp3=0, :ycp4=1, :delivered=16) 1 0.00904 0.00904 0.00904 0.00904
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='21', :hash='%;21;%', :ycp5=1, :ycp6=0, :ycp7=1, :delivered=16) 1 0.00861 0.00861 0.00861 0.00861
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='22', :hash='%;22;%', :ycp8=1, :ycp9=0, :ycp10=1, :delivered=16) 1 0.00774 0.00774 0.00774 0.00774
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='22', :hash='%;22;%', :ycp11=1, :ycp12=0, :ycp13=1, :delivered=16) 1 0.00768 0.00768 0.00768 0.00768
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='44', :hash='%;44;%', :ycp14=1, :ycp15=0, :ycp16=1, :delivered=16) 1 0.00598 0.00598 0.00598 0.00598
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='44', :hash='%;44;%', :ycp17=1, :ycp18=0, :ycp19=1, :delivered=16) 1 0.00585 0.00585 0.00585 0.00585
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='51', :hash='%;51;%', :ycp20=1, :ycp21=0, :ycp22=1, :delivered=16) 1 0.00494 0.00494 0.00494 0.00494
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='51', :hash='%;51;%', :ycp23=1, :ycp24=0, :ycp25=1, :delivered=16) 1 0.00476 0.00476 0.00476 0.00476
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='25', :hash='%;25;%', :ycp32=1, :ycp33=0, :ycp34=1, :delivered=16) 1 0.00445 0.00445 0.00445 0.00445
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=:ycp35 AND t.Incoming=:ycp36 AND t.IsMarketable=:ycp37) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='25', :hash='%;25;%', :ycp35=1, :ycp36=0, :ycp37=1, :delivered=16) 1 0.00424 0.00424 0.00424 0.00424
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=:ycp74 AND t.Incoming=:ycp75 AND t.IsMarketable=:ycp76) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='43', :hash='%;43;%', :ycp74=1, :ycp75=0, :ycp76=1, :delivered=16) 1 0.00414 0.00414 0.00414 0.00414
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=:ycp83 AND t.Incoming=:ycp84 AND t.IsMarketable=:ycp85) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='36', :hash='%;36;%', :ycp83=1, :ycp84=0, :ycp85=1, :delivered=16) 1 0.00413 0.00413 0.00413 0.00413
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=:ycp77 AND t.Incoming=:ycp78 AND t.IsMarketable=:ycp79) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='43', :hash='%;43;%', :ycp77=1, :ycp78=0, :ycp79=1, :delivered=16) 1 0.00408 0.00408 0.00408 0.00408
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=:ycp110 AND t.Incoming=:ycp111 AND t.IsMarketable=:ycp112) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='75', :hash='%;75;%', :ycp110=1, :ycp111=0, :ycp112=1, :delivered=16) 1 0.00367 0.00367 0.00367 0.00367
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=:ycp113 AND t.Incoming=:ycp114 AND t.IsMarketable=:ycp115) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='75', :hash='%;75;%', :ycp113=1, :ycp114=0, :ycp115=1, :delivered=16) 1 0.00365 0.00365 0.00365 0.00365
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='54', :hash='%;54;%', :ycp26=1, :ycp27=0, :ycp28=1, :delivered=16) 1 0.00309 0.00309 0.00309 0.00309
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=:ycp44 AND t.Incoming=:ycp45 AND t.IsMarketable=:ycp46) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='66', :hash='%;66;%', :ycp44=1, :ycp45=0, :ycp46=1, :delivered=16) 1 0.00308 0.00308 0.00308 0.00308
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=:ycp47 AND t.Incoming=:ycp48 AND t.IsMarketable=:ycp49) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='66', :hash='%;66;%', :ycp47=1, :ycp48=0, :ycp49=1, :delivered=16) 1 0.00300 0.00300 0.00300 0.00300
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='54', :hash='%;54;%', :ycp29=1, :ycp30=0, :ycp31=1, :delivered=16) 1 0.00279 0.00279 0.00279 0.00279
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 33 0.00277 0.00008 0.00005 0.00013
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='56', :hash='%;56;%', :ycp38=1, :ycp39=0, :ycp40=1, :delivered=16) 1 0.00268 0.00268 0.00268 0.00268
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=:ycp41 AND t.Incoming=:ycp42 AND t.IsMarketable=:ycp43) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='56', :hash='%;56;%', :ycp41=1, :ycp42=0, :ycp43=1, :delivered=16) 1 0.00267 0.00267 0.00267 0.00267
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 33 0.00265 0.00008 0.00004 0.00014
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=:ycp80 AND t.Incoming=:ycp81 AND t.IsMarketable=:ycp82) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='36', :hash='%;36;%', :ycp80=1, :ycp81=0, :ycp82=1, :delivered=16) 1 0.00232 0.00232 0.00232 0.00232
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=:ycp62 AND t.Incoming=:ycp63 AND t.IsMarketable=:ycp64) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='55', :hash='%;55;%', :ycp62=1, :ycp63=0, :ycp64=1, :delivered=16) 1 0.00215 0.00215 0.00215 0.00215
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=:ycp65 AND t.Incoming=:ycp66 AND t.IsMarketable=:ycp67) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='55', :hash='%;55;%', :ycp65=1, :ycp66=0, :ycp67=1, :delivered=16) 1 0.00210 0.00210 0.00210 0.00210
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=:ycp98 AND t.Incoming=:ycp99 AND t.IsMarketable=:ycp100) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp98=1, :ycp99=0, :ycp100=1, :delivered=16) 1 0.00201 0.00201 0.00201 0.00201
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=:ycp50 AND t.Incoming=:ycp51 AND t.IsMarketable=:ycp52) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp50=1, :ycp51=0, :ycp52=1, :delivered=16) 1 0.00197 0.00197 0.00197 0.00197
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=:ycp56 AND t.Incoming=:ycp57 AND t.IsMarketable=:ycp58) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp56=1, :ycp57=0, :ycp58=1, :delivered=16) 1 0.00194 0.00194 0.00194 0.00194
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=:ycp92 AND t.Incoming=:ycp93 AND t.IsMarketable=:ycp94) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp92=1, :ycp93=0, :ycp94=1, :delivered=16) 1 0.00189 0.00189 0.00189 0.00189
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=:ycp86 AND t.Incoming=:ycp87 AND t.IsMarketable=:ycp88) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp86=1, :ycp87=0, :ycp88=1, :delivered=16) 1 0.00189 0.00189 0.00189 0.00189
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=:ycp104 AND t.Incoming=:ycp105 AND t.IsMarketable=:ycp106) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp104=1, :ycp105=0, :ycp106=1, :delivered=16) 1 0.00177 0.00177 0.00177 0.00177
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1579852933) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Article`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `DictionaryDetail`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Dictionary`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='65') LIMIT 1) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='70') LIMIT 1) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1579852933, :id='tlue6gosfghq4io2h508c9ps8u') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='81') LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
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-Bucatarie') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='283') LIMIT 1) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='565') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='70') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2027') LIMIT 1) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1655') 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='565') LIMIT 1) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='276') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1240') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1306') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `Article`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1655') LIMIT 1) 1 0.00024 0.00024 0.00024 0.00024
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='14') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='127') LIMIT 1) 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='1655') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='65') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1943') LIMIT 1) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='81') 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1292') LIMIT 1) 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='44') 2 0.00019 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1949') LIMIT 1) 2 0.00018 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='546') 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='22') 2 0.00018 0.00009 0.00008 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='565') 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='1943') 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='50') 2 0.00017 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `DictionaryDetail`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='283') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='128') LIMIT 1) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1142') LIMIT 1) 2 0.00016 0.00008 0.00006 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2027') 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='51') 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='114') LIMIT 1) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='21') 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1247') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1269') LIMIT 1) 2 0.00015 0.00007 0.00006 0.00009
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1308') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1292') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='524') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='55') 2 0.00014 0.00007 0.00007 0.00007
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='14') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='36') 2 0.00013 0.00007 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='1142') 2 0.00013 0.00006 0.00003 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='127') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='54') 2 0.00013 0.00006 0.00005 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='56') 2 0.00013 0.00006 0.00004 0.00009
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='14') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
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 '%;14;%' 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.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `Dictionary`) 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='1949') 2 0.00012 0.00006 0.00005 0.00007
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1240') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1943') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='205') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='276') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2004') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='65') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='70') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1306') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='546') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='5') LIMIT 1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='67') 2 0.00010 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='23') 2 0.00010 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.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1247') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
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.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1678') LIMIT 1) 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='2027') 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='276') 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='81') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2004') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='114') 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='114') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='199') LIMIT 1) 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='1292') 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1269') 2 0.00008 0.00004 0.00003 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='25') 2 0.00008 0.00004 0.00003 0.00005
system.db.CDbCommand.query(SELECT 1 FROM `Category` `t` WHERE (`t`.Enabled=1) AND (ParentId = :selfId) LIMIT 1. Bound with :selfId='14') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='127') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1308') LIMIT 1) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='128') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='524') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1308') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='205') LIMIT 1) 1 0.00008 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='43') 2 0.00007 0.00004 0.00004 0.00004
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=:ycp59 AND t.Incoming=:ycp60 AND t.IsMarketable=:ycp61) GROUP BY t.Id LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp59=1, :ycp60=0, :ycp61=1) 1 0.00007 0.00007 0.00007 0.00007
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.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1949') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1247') 1 0.00007 0.00007 0.00007 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='53') 2 0.00007 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='524') LIMIT 1) 1 0.00007 0.00007 0.00007 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='66') 2 0.00006 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='75') 2 0.00006 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='546') 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=:ycp95 AND t.Incoming=:ycp96 AND t.IsMarketable=:ycp97) GROUP BY t.Id LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp95=1, :ycp96=0, :ycp97=1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1678') 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=:ycp101 AND t.Incoming=:ycp102 AND t.IsMarketable=:ycp103) GROUP BY t.Id LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp101=1, :ycp102=0, :ycp103=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=:ycp107 AND t.Incoming=:ycp108 AND t.IsMarketable=:ycp109) GROUP BY t.Id LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp107=1, :ycp108=0, :ycp109=1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='128') 1 0.00005 0.00005 0.00005 0.00005
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=:ycp89 AND t.Incoming=:ycp90 AND t.IsMarketable=:ycp91) GROUP BY t.Id LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp89=1, :ycp90=0, :ycp91=1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1240') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='205') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1306') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1678') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2004') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='199') 1 0.00004 0.00004 0.00004 0.00004
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=:ycp53 AND t.Incoming=:ycp54 AND t.IsMarketable=:ycp55) GROUP BY t.Id LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp53=1, :ycp54=0, :ycp55=1) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='283') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='199') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1142') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1269') 1 0.00003 0.00003 0.00003 0.00003

Long queries

Profiling Summary Report (Time: 0.25314s, Memory: 7,127KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.25317s, Memory: 7,127KB)
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') 33 0.00277 0.00008 0.00005 0.00013
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 33 0.00265 0.00008 0.00004 0.00014
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1292') LIMIT 1) 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='44') 2 0.00019 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1949') LIMIT 1) 2 0.00018 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='22') 2 0.00018 0.00009 0.00008 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='50') 2 0.00017 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1142') LIMIT 1) 2 0.00016 0.00008 0.00006 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='51') 2 0.00015 0.00008 0.00007 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='21') 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1269') LIMIT 1) 2 0.00015 0.00007 0.00006 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='55') 2 0.00014 0.00007 0.00007 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='36') 2 0.00013 0.00007 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='1142') 2 0.00013 0.00006 0.00003 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='54') 2 0.00013 0.00006 0.00005 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='56') 2 0.00013 0.00006 0.00004 0.00009
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1949') 2 0.00012 0.00006 0.00005 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='67') 2 0.00010 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='23') 2 0.00010 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1292') 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1269') 2 0.00008 0.00004 0.00003 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='25') 2 0.00008 0.00004 0.00003 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='43') 2 0.00007 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='53') 2 0.00007 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='66') 2 0.00006 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='75') 2 0.00006 0.00003 0.00003 0.00003

Classic summary

Profiling Summary Report (Time: 0.25328s, Memory: 7,127KB)
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=:ycp68 AND t.Incoming=:ycp69 AND t.IsMarketable=:ycp70) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='23', :hash='%;23;%', :ycp68=1, :ycp69=0, :ycp70=1, :delivered=16) 1 0.01413 0.01413 0.01413 0.01413
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=:ycp71 AND t.Incoming=:ycp72 AND t.IsMarketable=:ycp73) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='23', :hash='%;23;%', :ycp71=1, :ycp72=0, :ycp73=1, :delivered=16) 1 0.01369 0.01369 0.01369 0.01369
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='21', :hash='%;21;%', :ycp2=1, :ycp3=0, :ycp4=1, :delivered=16) 1 0.00904 0.00904 0.00904 0.00904
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='21', :hash='%;21;%', :ycp5=1, :ycp6=0, :ycp7=1, :delivered=16) 1 0.00861 0.00861 0.00861 0.00861
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='22', :hash='%;22;%', :ycp8=1, :ycp9=0, :ycp10=1, :delivered=16) 1 0.00774 0.00774 0.00774 0.00774
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='22', :hash='%;22;%', :ycp11=1, :ycp12=0, :ycp13=1, :delivered=16) 1 0.00768 0.00768 0.00768 0.00768
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='44', :hash='%;44;%', :ycp14=1, :ycp15=0, :ycp16=1, :delivered=16) 1 0.00598 0.00598 0.00598 0.00598
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='44', :hash='%;44;%', :ycp17=1, :ycp18=0, :ycp19=1, :delivered=16) 1 0.00585 0.00585 0.00585 0.00585
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='51', :hash='%;51;%', :ycp20=1, :ycp21=0, :ycp22=1, :delivered=16) 1 0.00494 0.00494 0.00494 0.00494
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='51', :hash='%;51;%', :ycp23=1, :ycp24=0, :ycp25=1, :delivered=16) 1 0.00476 0.00476 0.00476 0.00476
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='25', :hash='%;25;%', :ycp32=1, :ycp33=0, :ycp34=1, :delivered=16) 1 0.00445 0.00445 0.00445 0.00445
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=:ycp35 AND t.Incoming=:ycp36 AND t.IsMarketable=:ycp37) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='25', :hash='%;25;%', :ycp35=1, :ycp36=0, :ycp37=1, :delivered=16) 1 0.00424 0.00424 0.00424 0.00424
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=:ycp74 AND t.Incoming=:ycp75 AND t.IsMarketable=:ycp76) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='43', :hash='%;43;%', :ycp74=1, :ycp75=0, :ycp76=1, :delivered=16) 1 0.00414 0.00414 0.00414 0.00414
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=:ycp83 AND t.Incoming=:ycp84 AND t.IsMarketable=:ycp85) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='36', :hash='%;36;%', :ycp83=1, :ycp84=0, :ycp85=1, :delivered=16) 1 0.00413 0.00413 0.00413 0.00413
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=:ycp77 AND t.Incoming=:ycp78 AND t.IsMarketable=:ycp79) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='43', :hash='%;43;%', :ycp77=1, :ycp78=0, :ycp79=1, :delivered=16) 1 0.00408 0.00408 0.00408 0.00408
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=:ycp110 AND t.Incoming=:ycp111 AND t.IsMarketable=:ycp112) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='75', :hash='%;75;%', :ycp110=1, :ycp111=0, :ycp112=1, :delivered=16) 1 0.00367 0.00367 0.00367 0.00367
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=:ycp113 AND t.Incoming=:ycp114 AND t.IsMarketable=:ycp115) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='75', :hash='%;75;%', :ycp113=1, :ycp114=0, :ycp115=1, :delivered=16) 1 0.00365 0.00365 0.00365 0.00365
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='54', :hash='%;54;%', :ycp26=1, :ycp27=0, :ycp28=1, :delivered=16) 1 0.00309 0.00309 0.00309 0.00309
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=:ycp44 AND t.Incoming=:ycp45 AND t.IsMarketable=:ycp46) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='66', :hash='%;66;%', :ycp44=1, :ycp45=0, :ycp46=1, :delivered=16) 1 0.00308 0.00308 0.00308 0.00308
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=:ycp47 AND t.Incoming=:ycp48 AND t.IsMarketable=:ycp49) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='66', :hash='%;66;%', :ycp47=1, :ycp48=0, :ycp49=1, :delivered=16) 1 0.00300 0.00300 0.00300 0.00300
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='54', :hash='%;54;%', :ycp29=1, :ycp30=0, :ycp31=1, :delivered=16) 1 0.00279 0.00279 0.00279 0.00279
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 33 0.00277 0.00008 0.00005 0.00013
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='56', :hash='%;56;%', :ycp38=1, :ycp39=0, :ycp40=1, :delivered=16) 1 0.00268 0.00268 0.00268 0.00268
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=:ycp41 AND t.Incoming=:ycp42 AND t.IsMarketable=:ycp43) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='56', :hash='%;56;%', :ycp41=1, :ycp42=0, :ycp43=1, :delivered=16) 1 0.00267 0.00267 0.00267 0.00267
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 33 0.00265 0.00008 0.00004 0.00014
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=:ycp80 AND t.Incoming=:ycp81 AND t.IsMarketable=:ycp82) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='36', :hash='%;36;%', :ycp80=1, :ycp81=0, :ycp82=1, :delivered=16) 1 0.00232 0.00232 0.00232 0.00232
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=:ycp62 AND t.Incoming=:ycp63 AND t.IsMarketable=:ycp64) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='55', :hash='%;55;%', :ycp62=1, :ycp63=0, :ycp64=1, :delivered=16) 1 0.00215 0.00215 0.00215 0.00215
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=:ycp65 AND t.Incoming=:ycp66 AND t.IsMarketable=:ycp67) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='55', :hash='%;55;%', :ycp65=1, :ycp66=0, :ycp67=1, :delivered=16) 1 0.00210 0.00210 0.00210 0.00210
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=:ycp98 AND t.Incoming=:ycp99 AND t.IsMarketable=:ycp100) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp98=1, :ycp99=0, :ycp100=1, :delivered=16) 1 0.00201 0.00201 0.00201 0.00201
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=:ycp50 AND t.Incoming=:ycp51 AND t.IsMarketable=:ycp52) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp50=1, :ycp51=0, :ycp52=1, :delivered=16) 1 0.00197 0.00197 0.00197 0.00197
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=:ycp56 AND t.Incoming=:ycp57 AND t.IsMarketable=:ycp58) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp56=1, :ycp57=0, :ycp58=1, :delivered=16) 1 0.00194 0.00194 0.00194 0.00194
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=:ycp92 AND t.Incoming=:ycp93 AND t.IsMarketable=:ycp94) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp92=1, :ycp93=0, :ycp94=1, :delivered=16) 1 0.00189 0.00189 0.00189 0.00189
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=:ycp86 AND t.Incoming=:ycp87 AND t.IsMarketable=:ycp88) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp86=1, :ycp87=0, :ycp88=1, :delivered=16) 1 0.00189 0.00189 0.00189 0.00189
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=:ycp104 AND t.Incoming=:ycp105 AND t.IsMarketable=:ycp106) GROUP BY t.Id HAVING SUM(dd.Quantity) > 0 ORDER BY t.Price DESC LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp104=1, :ycp105=0, :ycp106=1, :delivered=16) 1 0.00177 0.00177 0.00177 0.00177
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1579852933) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Article`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `DictionaryDetail`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Dictionary`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='65') LIMIT 1) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='70') LIMIT 1) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1579852933, :id='tlue6gosfghq4io2h508c9ps8u') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='81') LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
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-Bucatarie') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='283') LIMIT 1) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='565') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='70') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2027') LIMIT 1) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1655') 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='565') LIMIT 1) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='276') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1240') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1306') LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `Article`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1655') LIMIT 1) 1 0.00024 0.00024 0.00024 0.00024
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='14') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='127') LIMIT 1) 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='1655') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='65') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1943') LIMIT 1) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='81') 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1292') LIMIT 1) 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='44') 2 0.00019 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1949') LIMIT 1) 2 0.00018 0.00009 0.00009 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='546') 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='22') 2 0.00018 0.00009 0.00008 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='565') 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='1943') 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='50') 2 0.00017 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `DictionaryDetail`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='283') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='128') LIMIT 1) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1142') LIMIT 1) 2 0.00016 0.00008 0.00006 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2027') 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='51') 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='114') LIMIT 1) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='21') 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1247') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1269') LIMIT 1) 2 0.00015 0.00007 0.00006 0.00009
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1308') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1292') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='524') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='55') 2 0.00014 0.00007 0.00007 0.00007
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='14') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='36') 2 0.00013 0.00007 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='1142') 2 0.00013 0.00006 0.00003 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='127') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='54') 2 0.00013 0.00006 0.00005 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='56') 2 0.00013 0.00006 0.00004 0.00009
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='14') LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
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 '%;14;%' 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.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `Dictionary`) 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='1949') 2 0.00012 0.00006 0.00005 0.00007
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1240') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1943') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='205') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='276') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='2004') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='65') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='70') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1306') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='546') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='5') LIMIT 1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='67') 2 0.00010 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='23') 2 0.00010 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.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1247') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
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.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1678') LIMIT 1) 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='2027') 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='276') 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='81') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='2004') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='114') 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='114') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='199') LIMIT 1) 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='1292') 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1269') 2 0.00008 0.00004 0.00003 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='25') 2 0.00008 0.00004 0.00003 0.00005
system.db.CDbCommand.query(SELECT 1 FROM `Category` `t` WHERE (`t`.Enabled=1) AND (ParentId = :selfId) LIMIT 1. Bound with :selfId='14') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='127') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1308') LIMIT 1) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='128') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='524') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1308') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='205') LIMIT 1) 1 0.00008 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='43') 2 0.00007 0.00004 0.00004 0.00004
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=:ycp59 AND t.Incoming=:ycp60 AND t.IsMarketable=:ycp61) GROUP BY t.Id LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp59=1, :ycp60=0, :ycp61=1) 1 0.00007 0.00007 0.00007 0.00007
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.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1949') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1247') 1 0.00007 0.00007 0.00007 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='53') 2 0.00007 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='524') LIMIT 1) 1 0.00007 0.00007 0.00007 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='66') 2 0.00006 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='75') 2 0.00006 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='546') 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=:ycp95 AND t.Incoming=:ycp96 AND t.IsMarketable=:ycp97) GROUP BY t.Id LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp95=1, :ycp96=0, :ycp97=1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1678') 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=:ycp101 AND t.Incoming=:ycp102 AND t.IsMarketable=:ycp103) GROUP BY t.Id LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp101=1, :ycp102=0, :ycp103=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=:ycp107 AND t.Incoming=:ycp108 AND t.IsMarketable=:ycp109) GROUP BY t.Id LIMIT 10. Bound with :catId='67', :hash='%;67;%', :ycp107=1, :ycp108=0, :ycp109=1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='128') 1 0.00005 0.00005 0.00005 0.00005
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=:ycp89 AND t.Incoming=:ycp90 AND t.IsMarketable=:ycp91) GROUP BY t.Id LIMIT 10. Bound with :catId='53', :hash='%;53;%', :ycp89=1, :ycp90=0, :ycp91=1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1240') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='205') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1306') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1678') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='2004') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='199') 1 0.00004 0.00004 0.00004 0.00004
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=:ycp53 AND t.Incoming=:ycp54 AND t.IsMarketable=:ycp55) GROUP BY t.Id LIMIT 10. Bound with :catId='50', :hash='%;50;%', :ycp53=1, :ycp54=0, :ycp55=1) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='283') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='199') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1142') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1269') 1 0.00003 0.00003 0.00003 0.00003