Created
November 6, 2013 15:51
-
-
Save abacha/7338469 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Type SQL Duration (ms) | |
| Client Load SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 85 LIMIT 1 148.472 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 5.111 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 237 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 3.374 | |
| Transaction Load SELECT `transactions`.* FROM `transactions` WHERE (value_date <= '2013-09-30' AND fund_id = 705 AND transactions.caution = 0 AND transactions.status_cd != 3) 3.257 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 219 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 3.128 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 403 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 2.971 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 141 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 2.592 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 260 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 2.454 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 141 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 2.340 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 268 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 2.204 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 228 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 2.165 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 237 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 2.104 | |
| Fund Load SELECT `funds`.* FROM `funds` 2.073 | |
| Account Load SELECT `accounts`.* FROM `accounts` 1.964 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 221 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.961 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 141 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.934 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 235 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.858 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 236 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.823 | |
| SELECT COUNT(*) FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) 1.808 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 403 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.794 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 140 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.777 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 396 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.770 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 244 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.767 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 196 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.703 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 140 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.701 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 409 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.696 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 244 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.658 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 403 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.633 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 221 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.621 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 196 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.581 | |
| Manager Load SELECT `managers`.* FROM `managers` 1.580 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 219 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.570 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 277 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.559 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 78 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.543 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 233 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.515 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 277 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.502 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 412 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.502 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 257 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.499 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 402 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.486 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 204 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.485 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 226 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.477 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 212 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.477 | |
| HistoricBalance Load SELECT `historic_balances`.* FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 108 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) AND (amount > 0 ) ORDER BY historic_balances.date desc, historic_balances.id desc 1.457 | |
| SQL SELECT `historic_balances`.`id` FROM `historic_balances` INNER JOIN `funds` ON `funds`.`id` = `historic_balances`.`fund_id` WHERE `historic_balances`.`account_id` = 219 AND (date <= '2013-09-30' AND fund_id = 705 AND caution = 0) ORDER BY historic_balances.date desc, historic_balances.id desc 1.451 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment