Long queries

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

Repeating queries

Profiling Summary Report (Time: 0.05194s, 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.05200s, Memory: 3,216KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.01042 0.01042 0.01042 0.01042
LayoutBeforeContent 1 0.00472 0.00472 0.00472 0.00472
BannerBackgroundWidgetMain 1 0.00380 0.00380 0.00380 0.00380
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00108 0.00108 0.00108 0.00108
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.00102 0.00102 0.00102 0.00102
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Banner`) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00076 0.00076 0.00076 0.00076
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.00065 0.00065 0.00065 0.00065
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=37) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1574468636) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1574468636, :id='n171d0j3b143akdju25fd4idnh') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 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.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1574468636)) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 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(SHOW CREATE TABLE `Page`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='64997f02a4e886b24c2b13c8a5891ca5' AND (expire=0 OR expire>1574468636)) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1574468636)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Contact') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00013 0.00013 0.00013 0.00013
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.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='Termeni si conditii') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 44) ORDER BY Priority LIMIT 8) 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`.`Name`=:yp0) LIMIT 1. Bound with :yp0='CONTACT') 1 0.00011 0.00011 0.00011 0.00011
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.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.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='Metode de plata') 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='plan-site') 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.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='Cum cumpar') 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-confidentialitate') 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.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='Contacteaza-ne') 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='Intrebari frecvente') 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='Harta site') 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`.`Id`='31') 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`.`Id`='42') LIMIT 1) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 43) ORDER BY Priority) 1 0.00007 0.00007 0.00007 0.00007
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.05317s, Memory: 3,218KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)

Repeating queries

Profiling Summary Report (Time: 0.05322s, 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.05327s, Memory: 3,218KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
DefaultIndexRenderPart1 1 0.01042 0.01042 0.01042 0.01042
LayoutBeforeContent 1 0.00472 0.00472 0.00472 0.00472
BannerBackgroundWidgetMain 1 0.00380 0.00380 0.00380 0.00380
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Category`) 1 0.00108 0.00108 0.00108 0.00108
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.00102 0.00102 0.00102 0.00102
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Banner`) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Page`) 1 0.00076 0.00076 0.00076 0.00076
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.00065 0.00065 0.00065 0.00065
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=37) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.execute(DELETE FROM `YiiSession` WHERE expire<:expire. Bound with :expire=1574468636) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `data` FROM `YiiSession` WHERE expire>:expire AND id=:id. Bound with :expire=1574468636, :id='n171d0j3b143akdju25fd4idnh') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `Category`) 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.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='ba2c23c517a370a364aee1b65dbb40c7' AND (expire=0 OR expire>1574468636)) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `Banner`) 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(SHOW CREATE TABLE `Page`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='64997f02a4e886b24c2b13c8a5891ca5' AND (expire=0 OR expire>1574468636)) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT value FROM YiiCache WHERE id='a4467ed383b0fef276351ea3f5450441' AND (expire=0 OR expire>1574468636)) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`PageName`=:yp0) LIMIT 1. Bound with :yp0='Confidentialitate') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `Footer`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT * FROM `Page` `t` WHERE (`t`.Enabled=1) AND (`t`.`Name`=:yp0) LIMIT 1. Bound with :yp0='Contact') 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.execute(DELETE FROM YiiCache WHERE id='53d56810a12119b883691471e9d46e3a') 1 0.00013 0.00013 0.00013 0.00013
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.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='Termeni si conditii') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 44) ORDER BY Priority LIMIT 8) 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`.`Name`=:yp0) LIMIT 1. Bound with :yp0='CONTACT') 1 0.00011 0.00011 0.00011 0.00011
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.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.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='Metode de plata') 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='plan-site') 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.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='Cum cumpar') 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-confidentialitate') 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.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='Contacteaza-ne') 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='Intrebari frecvente') 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='Harta site') 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`.`Id`='31') 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`.`Id`='42') LIMIT 1) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `Footer` `t` WHERE (`t`.Enabled=1) AND (TypeId = 43) ORDER BY Priority) 1 0.00007 0.00007 0.00007 0.00007
PublishFrontendAssets 1 0.00002 0.00002 0.00002 0.00002
LayoutContent 1 0.00000 0.00000 0.00000 0.00000