Îngrijire personală

Uscătoare

Uscătoare

Plăci pentru întins părul

Plăci pentru întins părul

Ondulatoare

Ondulatoare

Perii rotative

Perii rotative

Long queries

Profiling Summary Report (Time: 0.09496s, Memory: 3,916KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.09501s, Memory: 3,916KB)
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') 9 0.00082 0.00009 0.00006 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 9 0.00081 0.00009 0.00007 0.00013
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1720') LIMIT 1) 2 0.00019 0.00010 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='63') 2 0.00015 0.00008 0.00006 0.00009
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1720') 2 0.00014 0.00007 0.00005 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='62') 2 0.00013 0.00007 0.00006 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='64') 2 0.00012 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='65') 2 0.00012 0.00006 0.00006 0.00006

Classic summary

Profiling Summary Report (Time: 0.09517s, Memory: 3,916KB)
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=: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='62', :hash='%;62;%', :ycp2=1, :ycp3=0, :ycp4=1, :delivered=16) 1 0.00834 0.00834 0.00834 0.00834
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='62', :hash='%;62;%', :ycp5=1, :ycp6=0, :ycp7=1, :delivered=16) 1 0.00784 0.00784 0.00784 0.00784
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='64', :hash='%;64;%', :ycp14=1, :ycp15=0, :ycp16=1, :delivered=16) 1 0.00507 0.00507 0.00507 0.00507
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='64', :hash='%;64;%', :ycp17=1, :ycp18=0, :ycp19=1, :delivered=16) 1 0.00498 0.00498 0.00498 0.00498
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='63', :hash='%;63;%', :ycp8=1, :ycp9=0, :ycp10=1, :delivered=16) 1 0.00473 0.00473 0.00473 0.00473
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='63', :hash='%;63;%', :ycp11=1, :ycp12=0, :ycp13=1, :delivered=16) 1 0.00454 0.00454 0.00454 0.00454
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='65', :hash='%;65;%', :ycp20=1, :ycp21=0, :ycp22=1, :delivered=16) 1 0.00319 0.00319 0.00319 0.00319
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='65', :hash='%;65;%', :ycp23=1, :ycp24=0, :ycp25=1, :delivered=16) 1 0.00301 0.00301 0.00301 0.00301
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Article`) 1 0.00108 0.00108 0.00108 0.00108
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 9 0.00082 0.00009 0.00006 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 9 0.00081 0.00009 0.00007 0.00013
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `DictionaryDetail`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Dictionary`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1579855370) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1668') LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1725') LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1693') LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1725') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1693') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `Article`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1579855370, :id='u7ljn1j69ot1da9p6t9osi99s7') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1668') 1 0.00023 0.00023 0.00023 0.00023
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='1693') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1720') LIMIT 1) 2 0.00019 0.00010 0.00009 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1725') 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='63') 2 0.00015 0.00008 0.00006 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1716') LIMIT 1) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1668') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1718') LIMIT 1) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1719') LIMIT 1) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1720') 2 0.00014 0.00007 0.00005 0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `DictionaryDetail`) 1 0.00014 0.00014 0.00014 0.00014
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='60') 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='62') 2 0.00013 0.00007 0.00006 0.00008
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='60') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT 1 FROM `Category` `t` WHERE (`t`.Enabled=1) AND (ParentId = :selfId) LIMIT 1. Bound with :selfId='60') 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='64') 2 0.00012 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='65') 2 0.00012 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `Dictionary`) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='60') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1718') 1 0.00011 0.00011 0.00011 0.00011
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 '%;60;%' 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.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='45') 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='45') 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='1716') 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 FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1718') 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=:ycp0)) AND (Code = :code) LIMIT 1. Bound with :ycp0='26', :code='category_title') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1720') 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='1719') 1 0.00008 0.00008 0.00008 0.00008
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='Ingrijire-personala-Ingrijirea-parului') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1719') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1716') 1 0.00006 0.00006 0.00006 0.00006

Long queries

Profiling Summary Report (Time: 0.09680s, Memory: 3,918KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.09690s, Memory: 3,918KB)
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') 9 0.00082 0.00009 0.00006 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 9 0.00081 0.00009 0.00007 0.00013
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1720') LIMIT 1) 2 0.00019 0.00010 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='63') 2 0.00015 0.00008 0.00006 0.00009
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1720') 2 0.00014 0.00007 0.00005 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='62') 2 0.00013 0.00007 0.00006 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='64') 2 0.00012 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='65') 2 0.00012 0.00006 0.00006 0.00006

Classic summary

Profiling Summary Report (Time: 0.09697s, Memory: 3,918KB)
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=: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='62', :hash='%;62;%', :ycp2=1, :ycp3=0, :ycp4=1, :delivered=16) 1 0.00834 0.00834 0.00834 0.00834
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='62', :hash='%;62;%', :ycp5=1, :ycp6=0, :ycp7=1, :delivered=16) 1 0.00784 0.00784 0.00784 0.00784
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='64', :hash='%;64;%', :ycp14=1, :ycp15=0, :ycp16=1, :delivered=16) 1 0.00507 0.00507 0.00507 0.00507
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='64', :hash='%;64;%', :ycp17=1, :ycp18=0, :ycp19=1, :delivered=16) 1 0.00498 0.00498 0.00498 0.00498
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='63', :hash='%;63;%', :ycp8=1, :ycp9=0, :ycp10=1, :delivered=16) 1 0.00473 0.00473 0.00473 0.00473
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='63', :hash='%;63;%', :ycp11=1, :ycp12=0, :ycp13=1, :delivered=16) 1 0.00454 0.00454 0.00454 0.00454
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='65', :hash='%;65;%', :ycp20=1, :ycp21=0, :ycp22=1, :delivered=16) 1 0.00319 0.00319 0.00319 0.00319
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='65', :hash='%;65;%', :ycp23=1, :ycp24=0, :ycp25=1, :delivered=16) 1 0.00301 0.00301 0.00301 0.00301
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Article`) 1 0.00108 0.00108 0.00108 0.00108
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 9 0.00082 0.00009 0.00006 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='RESIGILATE') 9 0.00081 0.00009 0.00007 0.00013
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `DictionaryDetail`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Dictionary`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1579855370) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1668') LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1725') LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1693') LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1725') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1693') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `Article`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1579855370, :id='u7ljn1j69ot1da9p6t9osi99s7') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1668') 1 0.00023 0.00023 0.00023 0.00023
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='1693') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1720') LIMIT 1) 2 0.00019 0.00010 0.00009 0.00010
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1725') 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='63') 2 0.00015 0.00008 0.00006 0.00009
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1716') LIMIT 1) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1668') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1718') LIMIT 1) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT * FROM `Article` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='1719') LIMIT 1) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1720') 2 0.00014 0.00007 0.00005 0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `DictionaryDetail`) 1 0.00014 0.00014 0.00014 0.00014
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='60') 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='62') 2 0.00013 0.00007 0.00006 0.00008
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='60') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT 1 FROM `Category` `t` WHERE (`t`.Enabled=1) AND (ParentId = :selfId) LIMIT 1. Bound with :selfId='60') 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='64') 2 0.00012 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT Id, Link, Enabled FROM `Category` `t` WHERE (`t`.Enabled=1) AND (Id = :id) LIMIT 1. Bound with :id='65') 2 0.00012 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `Dictionary`) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='60') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1718') 1 0.00011 0.00011 0.00011 0.00011
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 '%;60;%' 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.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='45') 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='45') 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='1716') 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 FilePath FROM DocumentFile WHERE ArticleId = :id AND Enabled = 1 ORDER BY `Default` DESC, Priority. Bound with id='1718') 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=:ycp0)) AND (Code = :code) LIMIT 1. Bound with :ycp0='26', :code='category_title') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1720') 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='1719') 1 0.00008 0.00008 0.00008 0.00008
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='Ingrijire-personala-Ingrijirea-parului') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1719') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT Id FROM Article WHERE Id = :id. Bound with id='1716') 1 0.00006 0.00006 0.00006 0.00006