Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.04611s, Memory: 3,216KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00017 0.00009 0.00007 0.00010

Classic summary

Profiling Summary Report (Time: 0.04616s, Memory: 3,216KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.00901 0.00901 0.00901 0.00901
LayoutBeforeContent 1 0.00442 0.00442 0.00442 0.00442
BannerBackgroundWidgetMain 1 0.00357 0.00357 0.00357 0.00357
system.db.CDbCommand.query(SELECT (RAND() * Id) as random, t.* FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(t.StartDate) AND DATE(t.EndDate) AND t.Enabled = 1) ORDER BY t.Default DESC, random ASC LIMIT 10. Bound with :type=35) 1 0.00092 0.00092 0.00092 0.00092
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 `Banner`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT (RAND() * Id) as random, t.* FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(t.StartDate) AND DATE(t.EndDate) AND t.Enabled = 1) ORDER BY t.Default DESC, random ASC LIMIT 10. Bound with :type=36) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT (RAND() * Id) as random, t.* FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(t.StartDate) AND DATE(t.EndDate) AND t.Enabled = 1) ORDER BY t.Default DESC, random ASC LIMIT 10. Bound with :type=37) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Footer`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1574468469) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1574468469, :id='pc8u9hhtp2m6r2j8rfohue783p') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT * FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(StartDate) AND DATE(EndDate) AND Enabled = 1) LIMIT 4. Bound with :type=38) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `Page`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00017 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1574468469)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='64997f02a4e886b24c2b13c8a5891ca5' AND (expire=0 OR expire>1574468469)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1574468469)) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='38') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='42') LIMIT 1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='31') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Contact') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-utilizare-cookie-uri') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='termeni-si-conditii') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-retur') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='plan-site') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='29') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Transport si retururi') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='CONTACT') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 43) ORDER BY Priority) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Termeni si conditii') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-confidentialitate') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Cum cumpar') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 44) ORDER BY Priority LIMIT 8) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Feed-uri RSS') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Metode de plata') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Harta site') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Intrebari frecvente') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Contacteaza-ne') 1 0.00004 0.00004 0.00004 0.00004
PublishFrontendAssets 1 0.00003 0.00003 0.00003 0.00003
LayoutContent 1 0.00000 0.00000 0.00000 0.00000

Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.04749s, Memory: 3,218KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00017 0.00009 0.00007 0.00010

Classic summary

Profiling Summary Report (Time: 0.04755s, Memory: 3,218KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.00901 0.00901 0.00901 0.00901
LayoutBeforeContent 1 0.00442 0.00442 0.00442 0.00442
BannerBackgroundWidgetMain 1 0.00357 0.00357 0.00357 0.00357
system.db.CDbCommand.query(SELECT (RAND() * Id) as random, t.* FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(t.StartDate) AND DATE(t.EndDate) AND t.Enabled = 1) ORDER BY t.Default DESC, random ASC LIMIT 10. Bound with :type=35) 1 0.00092 0.00092 0.00092 0.00092
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 `Banner`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT (RAND() * Id) as random, t.* FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(t.StartDate) AND DATE(t.EndDate) AND t.Enabled = 1) ORDER BY t.Default DESC, random ASC LIMIT 10. Bound with :type=36) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT (RAND() * Id) as random, t.* FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(t.StartDate) AND DATE(t.EndDate) AND t.Enabled = 1) ORDER BY t.Default DESC, random ASC LIMIT 10. Bound with :type=37) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Footer`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1574468469) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1574468469, :id='pc8u9hhtp2m6r2j8rfohue783p') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT * FROM `Banner` `t` WHERE (`t`.Enabled=1) AND (t.TypeId = :type AND DATE(NOW()) BETWEEN DATE(StartDate) AND DATE(EndDate) AND Enabled = 1) LIMIT 4. Bound with :type=38) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `Page`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00017 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1574468469)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='64997f02a4e886b24c2b13c8a5891ca5' AND (expire=0 OR expire>1574468469)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1574468469)) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='38') LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='42') LIMIT 1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='31') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Contact') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-utilizare-cookie-uri') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='termeni-si-conditii') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-retur') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='plan-site') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='29') LIMIT 1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Transport si retururi') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='CONTACT') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 43) ORDER BY Priority) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Termeni si conditii') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-confidentialitate') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT Value FROM DictionaryDetail WHERE Code = ? AND DictionaryId = ?. Bound with 0='off', 1=26) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Cum cumpar') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 44) ORDER BY Priority LIMIT 8) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Feed-uri RSS') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Metode de plata') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Harta site') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Intrebari frecvente') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Contacteaza-ne') 1 0.00004 0.00004 0.00004 0.00004
PublishFrontendAssets 1 0.00003 0.00003 0.00003 0.00003
LayoutContent 1 0.00000 0.00000 0.00000 0.00000