Feel free to contact us at any time for more information on Shipanzee.

855.552.7447 or 905.761.8555

email: support@shipanzee.com

You can also hit Live Help for immediate assistance.


Profiling Summary Report (Time: 0.02688s, Memory: 1,596KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0, `sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE `o2sc_wssess`.`id`=3166517. Bound with :yp0=3166517, :yp1=3, :yp2='1785130596.4826', :yp3='{"xcart":"1785130596.4826","sid":3,"ip":"216.73.217.13","__returnUrl":"\\/contact"}', :yp4=1785130596) 1 0.00448 0.00448 0.00448 0.00448
system.db.CDbCommand.execute(INSERT INTO `o2sc_wssess` (`sid`, `xcart`, `data`, `created`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0=3, :yp1='1785130596.4826', :yp2='{"xcart":"1785130596.4826","sid":3,"ip":"216.73.217.13"}', :yp3=1785130596) 1 0.00426 0.00426 0.00426 0.00426
system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE `t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3) 3 0.00096 0.00032 0.00031 0.00033
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE (sid=3) AND (`t`.`url`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with :yp0='footer', :yp1=3) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t` WHERE (mid=126) AND (country='AU') ORDER BY `name` ASC) 2 0.00063 0.00032 0.00031 0.00032
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE mid=126) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `admin_banner` `t` WHERE (sid=3) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord ASC) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE sid=3 ORDER BY ord ASC) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT * FROM `themes` `t` WHERE (sid=3) AND (`t`.`sid`=:yp0 AND `t`.`active`=:yp1) LIMIT 1. Bound with :yp0=3, :yp1=1) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE (sid=3) AND (`t`.`url`=:yp0) LIMIT 1. Bound with :yp0='contact') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE (sid=3) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with :yp0='1785130596.4826') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `themes`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE (sid=3) AND (`t`.`xcart`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with :yp0='1785130596.4826', :yp1=3) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_countries` `t` WHERE (t.mid=126) AND (ship=1) ORDER BY `pos` ASC, `name` ASC) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `website`) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE sid=3) 1 0.00007 0.00007 0.00007 0.00007
Application Log
Timestamp Level Category Message
01:36:36.484934 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`)
01:36:36.485507 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`)
01:36:36.485574 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`)
01:36:36.485876 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`)
01:36:36.485977 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=3) AND (`t`.`xcart`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='1785130596.4826', :yp1=3)
01:36:36.486279 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=3) AND (`t`.`xcart`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='1785130596.4826', :yp1=3)
01:36:36.486377 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=3, :yp1='1785130596.4826',
:yp2='{"xcart":"1785130596.4826","sid":3,"ip":"216.73.217.13"}',
:yp3=1785130596)
01:36:36.490639 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=3,
:yp1='1785130596.4826',
:yp2='{"xcart":"1785130596.4826","sid":3,"ip":"216.73.217.13"}',
:yp3=1785130596)
01:36:36.490727 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=3) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with :yp0='1785130596.4826')
01:36:36.491039 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE
(sid=3) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with :yp0='1785130596.4826')
01:36:36.491080 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`)
01:36:36.491523 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`)
01:36:36.491539 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `themes`)
01:36:36.491844 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `themes`)
01:36:36.491864 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `themes` `t` WHERE (sid=3)
AND (`t`.`sid`=:yp0 AND `t`.`active`=:yp1) LIMIT 1. Bound with :yp0=3,
:yp1=1)
01:36:36.492180 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `themes` `t` WHERE (sid=3) AND
(`t`.`sid`=:yp0 AND `t`.`active`=:yp1) LIMIT 1. Bound with :yp0=3, :yp1=1)
01:36:36.492244 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`)
01:36:36.492578 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`)
01:36:36.492588 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`)
01:36:36.492913 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`)
01:36:36.492919 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE
mid=126)
01:36:36.493282 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE
mid=126)
01:36:36.493545 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`)
01:36:36.493890 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`)
01:36:36.493916 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `website`)
01:36:36.494016 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `website`)
01:36:36.494029 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
01:36:36.494353 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
01:36:36.494400 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`)
01:36:36.494761 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`)
01:36:36.494816 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`)
01:36:36.495151 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`)
01:36:36.495160 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_banner` `t` WHERE
(sid=3) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord
ASC)
01:36:36.495495 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_banner` `t` WHERE
(sid=3) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord
ASC)
01:36:36.495562 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`)
01:36:36.495913 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`)
01:36:36.495929 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`)
01:36:36.496232 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`)
01:36:36.496238 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE
sid=3 ORDER BY ord ASC)
01:36:36.496571 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE
sid=3 ORDER BY ord ASC)
01:36:36.496634 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`)
01:36:36.496947 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`)
01:36:36.496954 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`)
01:36:36.497262 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`)
01:36:36.497267 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE
sid=3)
01:36:36.497334 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE sid=3)
01:36:36.497356 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
01:36:36.497682 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
01:36:36.497797 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`)
01:36:36.498140 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`)
01:36:36.498158 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`)
01:36:36.498526 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`)
01:36:36.498549 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE
(sid=3) AND (`t`.`url`=:yp0) LIMIT 1. Bound with :yp0='contact')
01:36:36.498862 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE
(sid=3) AND (`t`.`url`=:yp0) LIMIT 1. Bound with :yp0='contact')
01:36:36.499001 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`=3166517. Bound with :yp0=3166517, :yp1=3,
:yp2='1785130596.4826',
:yp3='{"xcart":"1785130596.4826","sid":3,"ip":"216.73.217.13","__returnUrl":"\\/contact"}',
:yp4=1785130596)
01:36:36.503485 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`=3166517. Bound with :yp0=3166517, :yp1=3,
:yp2='1785130596.4826',
:yp3='{"xcart":"1785130596.4826","sid":3,"ip":"216.73.217.13","__returnUrl":"\\/contact"}',
:yp4=1785130596)
01:36:36.503861 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`)
01:36:36.504585 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`)
01:36:36.504616 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`)
01:36:36.504997 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`)
01:36:36.505017 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_countries`
`t` WHERE (t.mid=126) AND (ship=1) ORDER BY `pos` ASC, `name` ASC)
01:36:36.505256 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_countries` `t`
WHERE (t.mid=126) AND (ship=1) ORDER BY `pos` ASC, `name` ASC)
01:36:36.505331 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`)
01:36:36.505753 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`)
01:36:36.505770 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`)
01:36:36.506079 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`)
01:36:36.506088 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=126) AND (country='AU') ORDER BY `name` ASC)
01:36:36.506413 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=126) AND (country='AU') ORDER BY `name` ASC)
01:36:36.506444 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=126) AND (country='AU') ORDER BY `name` ASC)
01:36:36.506753 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t`
WHERE (mid=126) AND (country='AU') ORDER BY `name` ASC)
01:36:36.506911 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
01:36:36.507219 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
01:36:36.507433 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE
(sid=3) AND (`t`.`url`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='footer', :yp1=3)
01:36:36.508091 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE
(sid=3) AND (`t`.`url`=:yp0 AND `t`.`sid`=:yp1) LIMIT 1. Bound with
:yp0='footer', :yp1=3)