Profiling Summary Report (Time: 0.02573s, Memory: 1,651KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.execute(INSERT INTO `o2sc_wssess` (`sid`, `xcart`, `data`, `created`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0=348, :yp1='1785036293.9307', :yp2='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212"}', :yp3=1785036293) 1 0.00417 0.00417 0.00417 0.00417
system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0, `sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE `o2sc_wssess`.`id`=3165470. Bound with :yp0=3165470, :yp1=348, :yp2='1785036293.9307', :yp3='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212","language":"en","__returnUrl":"\\/"}', :yp4=1785036293) 1 0.00406 0.00406 0.00406 0.00406
system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0, `sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE `o2sc_wssess`.`id`=3165470. Bound with :yp0=3165470, :yp1=348, :yp2='1785036293.9307', :yp3='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212","language":"en"}', :yp4=1785036293) 1 0.00390 0.00390 0.00390 0.00390
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE `t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348) 3 0.00033 0.00011 0.00009 0.00012
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE (sid=348) AND (`t`.`xcart`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with :yp0='1785036293.9307', :yp1=348) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE (sid=348) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with :yp0='1785036293.9307') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t` WHERE (mid=324) AND (country='CA') ORDER BY `name` ASC) 2 0.00015 0.00008 0.00007 0.00008
system.db.CDbCommand.query(SHOW CREATE TABLE `website`) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE mid=324) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `themes`) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE sid=348 ORDER BY ord ASC) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `themes` `t` WHERE (sid=348) AND (`t`.`sid`=:yp0 AND `t`.`active`=:yp1) LIMIT 1. Bound with :yp0=348, :yp1=1) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `admin_banner` `t` WHERE (sid=348) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord ASC) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_countries` `t` WHERE (t.mid=324) AND (ship=1) ORDER BY `pos` ASC, `name` ASC) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE (sid=348) AND (`t`.`url`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with :yp0='footer', :yp1=348) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE sid=348) 1 0.00007 0.00007 0.00007 0.00007
Application Log
Timestamp Level Category Message
23:24:53.933053 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`)
23:24:53.933614 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`)
23:24:53.933681 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`)
23:24:53.933799 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`)
23:24:53.933903 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=348) AND (`t`.`xcart`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='1785036293.9307', :yp1=348)
23:24:53.934195 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=348) AND (`t`.`xcart`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='1785036293.9307', :yp1=348)
23:24:53.934307 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(INSERT INTO `o2sc_wssess` (`sid`,
`xcart`, `data`, `created`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with
:yp0=348, :yp1='1785036293.9307',
:yp2='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212"}',
:yp3=1785036293)
23:24:53.938479 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(INSERT INTO `o2sc_wssess` (`sid`, `xcart`,
`data`, `created`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0=348,
:yp1='1785036293.9307',
:yp2='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212"}',
:yp3=1785036293)
23:24:53.938560 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=348) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with
:yp0='1785036293.9307')
23:24:53.938805 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=348) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with
:yp0='1785036293.9307')
23:24:53.938846 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`)
23:24:53.939296 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`)
23:24:53.939311 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `themes`)
23:24:53.939414 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `themes`)
23:24:53.939434 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `themes` `t` WHERE (sid=348)
AND (`t`.`sid`=:yp0 AND `t`.`active`=:yp1) LIMIT 1. Bound with :yp0=348,
:yp1=1)
23:24:53.939531 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `themes` `t` WHERE (sid=348)
AND (`t`.`sid`=:yp0 AND `t`.`active`=:yp1) LIMIT 1. Bound with :yp0=348,
:yp1=1)
23:24:53.939626 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0,
`sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE
`o2sc_wssess`.`id`=3165470. Bound with :yp0=3165470, :yp1=348,
:yp2='1785036293.9307',
:yp3='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212","language":"en"}',
:yp4=1785036293)
23:24:53.943522 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0,
`sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE
`o2sc_wssess`.`id`=3165470. Bound with :yp0=3165470, :yp1=348,
:yp2='1785036293.9307',
:yp3='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212","language":"en"}',
:yp4=1785036293)
23:24:53.943609 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`)
23:24:53.943990 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`)
23:24:53.944001 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`)
23:24:53.944112 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`)
23:24:53.944118 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE
mid=324)
23:24:53.944240 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE
mid=324)
23:24:53.944406 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`)
23:24:53.944768 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`)
23:24:53.944785 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `website`)
23:24:53.944914 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `website`)
23:24:53.944926 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348)
23:24:53.945039 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348)
23:24:53.945082 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`)
23:24:53.945452 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`)
23:24:53.945506 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`)
23:24:53.945627 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`)
23:24:53.945636 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `admin_banner` `t` WHERE
(sid=348) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord
ASC)
23:24:53.945729 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `admin_banner` `t` WHERE
(sid=348) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord
ASC)
23:24:53.945771 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`)
23:24:53.946110 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`)
23:24:53.946125 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`)
23:24:53.946239 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`)
23:24:53.946245 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE
sid=348 ORDER BY ord ASC)
23:24:53.946347 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE
sid=348 ORDER BY ord ASC)
23:24:53.946494 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`)
23:24:53.946799 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`)
23:24:53.946808 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`)
23:24:53.946918 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`)
23:24:53.946923 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE
sid=348)
23:24:53.946988 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE
sid=348)
23:24:53.947009 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348)
23:24:53.947102 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348)
23:24:53.947242 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0,
`sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE
`o2sc_wssess`.`id`=3165470. Bound with :yp0=3165470, :yp1=348,
:yp2='1785036293.9307',
:yp3='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212","language":"en","__returnUrl":"\\/"}',
:yp4=1785036293)
23:24:53.951306 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0,
`sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE
`o2sc_wssess`.`id`=3165470. Bound with :yp0=3165470, :yp1=348,
:yp2='1785036293.9307',
:yp3='{"xcart":"1785036293.9307","sid":348,"ip":"216.73.216.212","language":"en","__returnUrl":"\\/"}',
:yp4=1785036293)
23:24:53.951767 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`)
23:24:53.952284 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`)
23:24:53.952316 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`)
23:24:53.952442 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`)
23:24:53.952459 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_countries`
`t` WHERE (t.mid=324) AND (ship=1) ORDER BY `pos` ASC, `name` ASC)
23:24:53.952548 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_countries` `t`
WHERE (t.mid=324) AND (ship=1) ORDER BY `pos` ASC, `name` ASC)
23:24:53.952617 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`)
23:24:53.952975 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`)
23:24:53.952987 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`)
23:24:53.953092 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`)
23:24:53.953099 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=324) AND (country='CA') ORDER BY `name` ASC)
23:24:53.953181 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=324) AND (country='CA') ORDER BY `name` ASC)
23:24:53.953219 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=324) AND (country='CA') ORDER BY `name` ASC)
23:24:53.953293 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=324) AND (country='CA') ORDER BY `name` ASC)
23:24:53.953788 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348)
23:24:53.953912 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=348)
23:24:53.954369 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`)
23:24:53.954720 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`)
23:24:53.954744 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`)
23:24:53.954844 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`)
23:24:53.954868 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE
(sid=348) AND (`t`.`url`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='footer', :yp1=348)
23:24:53.954957 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE
(sid=348) AND (`t`.`url`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='footer', :yp1=348)