перепроектировать

Application Log
Timestamp Level Category Message
17:15:29.867821 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`tbl_bazar_similar`)
17:15:29.868747 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_bazar_similar`)
17:15:29.868866 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_bazar_similar`)
17:15:29.869127 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_bazar_similar`)
17:15:29.869302 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`tbl_bazar_basifier`)
17:15:29.870104 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_bazar_basifier`)
17:15:29.870157 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_bazar_basifier`)
17:15:29.870404 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_bazar_basifier`)
17:15:29.870563 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`term` AS `t0_c0`, `t`.`slice`
AS `t0_c1`, `t`.`similar` AS `t0_c2`, `t`.`weight` AS `t0_c3`,
`basifier`.`wf` AS `t1_c0`, `basifier`.`term` AS `t1_c1` FROM
`tbl_bazar_similar` `t`  LEFT OUTER JOIN `tbl_bazar_basifier` `basifier` ON
(`t`.`term`=`basifier`.`term`) WHERE (slice = :slice AND wf = :wf) ORDER BY
weight DESC)
17:15:29.873487 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`term` AS `t0_c0`, `t`.`slice` AS
`t0_c1`, `t`.`similar` AS `t0_c2`, `t`.`weight` AS `t0_c3`, `basifier`.`wf`
AS `t1_c0`, `basifier`.`term` AS `t1_c1` FROM `tbl_bazar_similar` `t`  LEFT
OUTER JOIN `tbl_bazar_basifier` `basifier` ON
(`t`.`term`=`basifier`.`term`) WHERE (slice = :slice AND wf = :wf) ORDER BY
weight DESC)
17:15:29.875355 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_action_log`)
17:15:29.876117 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_action_log`)
17:15:29.876229 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_action_log`)
17:15:29.876420 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_action_log`)
17:15:29.876504 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`tbl_action_log_bazar`)
17:15:29.877191 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM
`tbl_action_log_bazar`)
17:15:29.877306 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_action_log_bazar`)
17:15:29.877449 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_action_log_bazar`)
Profiling Summary Report (Time: 0.01449s, Memory: 1,102KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT `t`.`term` AS `t0_c0`, `t`.`slice` AS `t0_c1`, `t`.`similar` AS `t0_c2`, `t`.`weight` AS `t0_c3`, `basifier`.`wf` AS `t1_c0`, `basifier`.`term` AS `t1_c1` FROM `tbl_bazar_similar` `t` LEFT OUTER JOIN `tbl_bazar_basifier` `basifier` ON (`t`.`term`=`basifier`.`term`) WHERE (slice = :slice AND wf = :wf) ORDER BY weight DESC) 1 0.00292 0.00292 0.00292 0.00292
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_bazar_similar`) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_bazar_basifier`) 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_action_log`) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_action_log_bazar`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_bazar_similar`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_bazar_basifier`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_action_log`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_action_log_bazar`) 1 0.00014 0.00014 0.00014 0.00014