Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.05049s, Memory: 3,074KB)
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.00022 0.00011 0.00011 0.00011

Classic summary

Profiling Summary Report (Time: 0.05054s, Memory: 3,074KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.00797 0.00797 0.00797 0.00797
LayoutBeforeContent 1 0.00525 0.00525 0.00525 0.00525
BannerBackgroundWidgetMain 1 0.00414 0.00414 0.00414 0.00414
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Banner`) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00077 0.00077 0.00077 0.00077
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.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1580044033) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Footer`) 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.00060 0.00060 0.00060 0.00060
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.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1580044033)) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='64997f02a4e886b24c2b13c8a5891ca5' AND (expire=0 OR expire>1580044033)) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00024 0.00024 0.00024 0.00024
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.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00022 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1580044033, :id='m02039uts5lgbuav83j1a5ajp2') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1580044033)) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `Page`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00014 0.00014 0.00014 0.00014
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.00013 0.00013 0.00013 0.00013
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.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.00011 0.00011 0.00011 0.00011
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(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='29') 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`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Feed-uri RSS') 1 0.00010 0.00010 0.00010 0.00010
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.00010 0.00010 0.00010 0.00010
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-retur') 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 `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 44) ORDER BY Priority LIMIT 8) 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 `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 43) ORDER BY Priority) 1 0.00009 0.00009 0.00009 0.00009
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`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Cum cumpar') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='42') LIMIT 1) 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 * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Metode de plata') 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='Transport si retururi') 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='Contacteaza-ne') 1 0.00006 0.00006 0.00006 0.00006
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.00006 0.00006 0.00006 0.00006
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
PublishFrontendAssets 1 0.00005 0.00005 0.00005 0.00005
LayoutContent 1 0.00000 0.00000 0.00000 0.00000

Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.05191s, Memory: 3,076KB)
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.00022 0.00011 0.00011 0.00011

Classic summary

Profiling Summary Report (Time: 0.05195s, Memory: 3,076KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.00797 0.00797 0.00797 0.00797
LayoutBeforeContent 1 0.00525 0.00525 0.00525 0.00525
BannerBackgroundWidgetMain 1 0.00414 0.00414 0.00414 0.00414
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Banner`) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00077 0.00077 0.00077 0.00077
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.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1580044033) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Footer`) 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.00060 0.00060 0.00060 0.00060
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.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1580044033)) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='64997f02a4e886b24c2b13c8a5891ca5' AND (expire=0 OR expire>1580044033)) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00024 0.00024 0.00024 0.00024
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.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00022 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1580044033, :id='m02039uts5lgbuav83j1a5ajp2') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1580044033)) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `Page`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00014 0.00014 0.00014 0.00014
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.00013 0.00013 0.00013 0.00013
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.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.00011 0.00011 0.00011 0.00011
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(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='29') 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`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Feed-uri RSS') 1 0.00010 0.00010 0.00010 0.00010
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.00010 0.00010 0.00010 0.00010
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-retur') 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 `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 44) ORDER BY Priority LIMIT 8) 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 `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 43) ORDER BY Priority) 1 0.00009 0.00009 0.00009 0.00009
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`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Cum cumpar') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='42') LIMIT 1) 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 * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Metode de plata') 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='Transport si retururi') 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='Contacteaza-ne') 1 0.00006 0.00006 0.00006 0.00006
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.00006 0.00006 0.00006 0.00006
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
PublishFrontendAssets 1 0.00005 0.00005 0.00005 0.00005
LayoutContent 1 0.00000 0.00000 0.00000 0.00000