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.02885s, Memory: 1,602KB)
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=3, :yp1='1785179843.7902', :yp2='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183"}', :yp3=1785179843) 1 0.00453 0.00453 0.00453 0.00453
system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0, `sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE `o2sc_wssess`.`id`=3167528. Bound with :yp0=3167528, :yp1=3, :yp2='1785179843.7902', :yp3='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183","language":"en"}', :yp4=1785179843) 1 0.00428 0.00428 0.00428 0.00428
system.db.CDbCommand.execute(UPDATE `o2sc_wssess` SET `id`=:yp0, `sid`=:yp1, `xcart`=:yp2, `data`=:yp3, `created`=:yp4 WHERE `o2sc_wssess`.`id`=3167528. Bound with :yp0=3167528, :yp1=3, :yp2='1785179843.7902', :yp3='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183","language":"en","__returnUrl":"\\/contact"}', :yp4=1785179843) 1 0.00416 0.00416 0.00416 0.00416
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM `o2sc_wssess` `t` WHERE (sid=3) AND (`t`.`xcart`=:yp0) LIMIT 1. Bound with :yp0='1785179843.7902') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE `t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3) 3 0.00039 0.00013 0.00009 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`) 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(SHOW CREATE TABLE `o2sc_states`) 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='1785179843.7902', :yp1=3) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE mid=126) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `themes`) 1 0.00026 0.00026 0.00026 0.00026
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.00026 0.00026 0.00026 0.00026
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.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `website`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT DISTINCT * FROM `o2sc_states` `t` WHERE (mid=126) AND (country='AU') ORDER BY `name` ASC) 2 0.00017 0.00009 0.00008 0.00009
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_menus`) 1 0.00011 0.00011 0.00011 0.00011
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 `admin_banner`) 1 0.00011 0.00011 0.00011 0.00011
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.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 `admin_banner` `t` WHERE (sid=3) AND (active='yes' AND file<>'' AND file IS NOT NULL) ORDER BY ord ASC) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE sid=3 ORDER BY ord ASC) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE sid=3) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `admin_pages` `t` WHERE (sid=3) AND (`t`.`url`=:yp0) LIMIT 1. Bound with :yp0='contact') 1 0.00008 0.00008 0.00008 0.00008
Application Log
Timestamp Level Category Message
15:17:23.791727 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`)
15:17:23.792280 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_wssess`)
15:17:23.792309 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`)
15:17:23.792429 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_wssess`)
15:17:23.792488 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='1785179843.7902', :yp1=3)
15:17:23.792781 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='1785179843.7902', :yp1=3)
15:17:23.792865 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='1785179843.7902',
:yp2='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183"}',
:yp3=1785179843)
15:17:23.797391 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='1785179843.7902',
:yp2='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183"}',
:yp3=1785179843)
15:17:23.797483 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='1785179843.7902')
15:17:23.797884 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='1785179843.7902')
15:17:23.797939 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`)
15:17:23.798487 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `themes`)
15:17:23.798505 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `themes`)
15:17:23.798768 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `themes`)
15:17:23.798789 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)
15:17:23.799001 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)
15:17:23.799067 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`=3167528. Bound with :yp0=3167528, :yp1=3,
:yp2='1785179843.7902',
:yp3='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183","language":"en"}',
:yp4=1785179843)
15:17:23.803345 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`=3167528. Bound with :yp0=3167528, :yp1=3,
:yp2='1785179843.7902',
:yp3='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183","language":"en"}',
:yp4=1785179843)
15:17:23.803467 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`)
15:17:23.804116 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_ce_ms`)
15:17:23.804142 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`)
15:17:23.804524 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_ce_ms`)
15:17:23.804546 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE
mid=126)
15:17:23.804831 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `o2sc_ce_ms` `t` WHERE
mid=126)
15:17:23.805166 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`)
15:17:23.805665 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `website`)
15:17:23.805686 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `website`)
15:17:23.805891 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `website`)
15:17:23.805927 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
15:17:23.806126 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
15:17:23.806190 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`)
15:17:23.806581 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_banner`)
15:17:23.806612 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`)
15:17:23.806720 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_banner`)
15:17:23.806727 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)
15:17:23.806823 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)
15:17:23.806881 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`)
15:17:23.807224 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menuitems`)
15:17:23.807239 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`)
15:17:23.807347 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menuitems`)
15:17:23.807353 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE
sid=3 ORDER BY ord ASC)
15:17:23.807446 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_menuitems` `t` WHERE
sid=3 ORDER BY ord ASC)
15:17:23.807507 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`)
15:17:23.807863 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_menus`)
15:17:23.807872 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`)
15:17:23.807984 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_menus`)
15:17:23.807988 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE
sid=3)
15:17:23.808074 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `admin_menus` `t` WHERE sid=3)
15:17:23.808098 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
15:17:23.808193 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
15:17:23.808310 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`)
15:17:23.808660 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `admin_pages`)
15:17:23.808680 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`)
15:17:23.808779 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `admin_pages`)
15:17:23.808798 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')
15:17:23.808880 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')
15:17:23.809019 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`=3167528. Bound with :yp0=3167528, :yp1=3,
:yp2='1785179843.7902',
:yp3='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183","language":"en","__returnUrl":"\\/contact"}',
:yp4=1785179843)
15:17:23.813174 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`=3167528. Bound with :yp0=3167528, :yp1=3,
:yp2='1785179843.7902',
:yp3='{"xcart":"1785179843.7902","sid":3,"ip":"216.73.216.183","language":"en","__returnUrl":"\\/contact"}',
:yp4=1785179843)
15:17:23.813553 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`)
15:17:23.814193 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_countries`)
15:17:23.814224 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`)
15:17:23.814637 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_countries`)
15:17:23.814659 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)
15:17:23.814915 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)
15:17:23.814996 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`)
15:17:23.815447 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `o2sc_states`)
15:17:23.815465 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`)
15:17:23.815768 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SHOW CREATE TABLE `o2sc_states`)
15:17:23.815777 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)
15:17:23.815859 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)
15:17:23.815888 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)
15:17:23.815979 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)
15:17:23.816098 profile system.db.CDbCommand.query 
begin:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
15:17:23.816191 profile system.db.CDbCommand.query 
end:system.db.CDbCommand.query(SELECT * FROM `website` `t` WHERE
`t`.`id`=:yp0 LIMIT 1. Bound with :yp0=3)
15:17:23.816406 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)
15:17:23.816508 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)