Collection
Price
Profiling Summary Report (Time: 0.32387s, Memory: 4,186KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT `c`.*,`gc`.`countryName` FROM `ubi_clients`AS `c` LEFT JOIN `glob_countries` AS `gc` ON `c`.`idCountries` = `gc`.`IdCountries` WHERE `c`.`idClients`=8586) 5 0.00394 0.00079 0.00066 0.00101
system.db.CDbCommand.query(SELECT * FROM `ubi_clients_domain` WHERE `domainName`="5lb.ubicross.net") 2 0.00158 0.00079 0.00075 0.00083
system.db.CDbCommand.query(SELECT * FROM `ubi_clients_domain` WHERE `idClient`="8586" AND `primaryDomain`=1) 1 0.00102 0.00102 0.00102 0.00102
system.db.CDbCommand.query(SELECT `t`.`name` AS themeName, `t`.`styleversion`, `o`.`logo`, `o`.`logoAlt`, `c`.`storeName`, `o`.`timeZone`, `u`.`emailConfirm` FROM `ubicross_main`.`ubi_clientoptions` AS `o` LEFT JOIN `ubicross_main`.`ubi_themes` AS `t` ON `o`.`idTheme`=`t`.`idThemes` LEFT JOIN `ubicross_main`.`ubi_clients` AS `c` ON `o`.`idClient`=`c`.`idClients` LEFT JOIN `ubicross_main`.`ubi_users` AS `u` ON `u`.`idClients`=`c`.`idClients` WHERE `u`.`emailConfirm` = "1" && `o`.`idClient` = 8586) 1 0.00095 0.00095 0.00095 0.00095