Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.04738s, 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.00020 0.00010 0.00009 0.00011

Classic summary

Profiling Summary Report (Time: 0.04743s, Memory: 3,216KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.00915 0.00915 0.00915 0.00915
LayoutBeforeContent 1 0.00451 0.00451 0.00451 0.00451
BannerBackgroundWidgetMain 1 0.00361 0.00361 0.00361 0.00361
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00095 0.00095 0.00095 0.00095
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.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Banner`) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Footer`) 1 0.00063 0.00063 0.00063 0.00063
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.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1574468474, :id='v2f8mi280nvskmkdke651r3pbr') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1574468474) 1 0.00022 0.00022 0.00022 0.00022
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.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1574468474)) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00020 0.00010 0.00009 0.00011
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1574468474)) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `Page`) 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>1574468474)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 1 0.00011 0.00011 0.00011 0.00011
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.00011 0.00011 0.00011 0.00011
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 `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='CONTACT') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='38') 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`.`Link`=: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`.`Id`='31') 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`='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`.`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 `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='Metode de plata') 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='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`.`Link`=:yp0) LIMIT 1. Bound with :yp0='plan-site') 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`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Contact') 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`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-retur') 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='Feed-uri RSS') 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 `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
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
PublishFrontendAssets 1 0.00002 0.00002 0.00002 0.00002
LayoutContent 1 0.00000 0.00000 0.00000 0.00000

Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.04861s, 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.00020 0.00010 0.00009 0.00011

Classic summary

Profiling Summary Report (Time: 0.04866s, Memory: 3,218KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.00915 0.00915 0.00915 0.00915
LayoutBeforeContent 1 0.00451 0.00451 0.00451 0.00451
BannerBackgroundWidgetMain 1 0.00361 0.00361 0.00361 0.00361
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00095 0.00095 0.00095 0.00095
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.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Banner`) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Footer`) 1 0.00063 0.00063 0.00063 0.00063
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.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1574468474, :id='v2f8mi280nvskmkdke651r3pbr') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1574468474) 1 0.00022 0.00022 0.00022 0.00022
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.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1574468474)) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='37') LIMIT 1) 2 0.00020 0.00010 0.00009 0.00011
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1574468474)) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `Page`) 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>1574468474)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `Category` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Produse') 1 0.00011 0.00011 0.00011 0.00011
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.00011 0.00011 0.00011 0.00011
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 `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='CONTACT') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Id`='38') 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`.`Link`=: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`.`Id`='31') 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`='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`.`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 `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='Metode de plata') 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='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`.`Link`=:yp0) LIMIT 1. Bound with :yp0='plan-site') 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`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Contact') 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`.`Link`=:yp0) LIMIT 1. Bound with :yp0='politica-de-retur') 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='Feed-uri RSS') 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 `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
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
PublishFrontendAssets 1 0.00002 0.00002 0.00002 0.00002
LayoutContent 1 0.00000 0.00000 0.00000 0.00000