Guest User

Untitled

a guest
Sep 26th, 2012
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.97 KB | None | 0 0
  1. <table class="cake-sql-log" id="cakeSqlLog_1348699307506384ab11b1d0_42787993" summary="Cake SQL Log" cellspacing="0"><caption>(default) 6 queries took 0 ms</caption> <thead>
  2. <tr><th>Nr</th><th>Query</th><th>Error</th><th>Affected</th><th>Num. rows</th><th>Took (ms)</th></tr>
  3. </thead>
  4. <tbody>
  5. <tr><td>1</td><td>SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`status`, `User`.`code`, `User`.`created`, `User`.`lastlogin`, `User`.`ipaddress`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`gender`, `Profile`.`dob`, `Profile`.`location`, `Profile`.`bio` FROM `db52704_favorr`.`users` AS `User` LEFT JOIN `db52704_favorr`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 6 LIMIT 1</td><td></td><td style = "text-align: right">1</td><td style = "text-align: right">1</td><td style = "text-align: right">0</td></tr>
  6. <tr><td>2</td><td>SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`status`, `User`.`code`, `User`.`created`, `User`.`lastlogin`, `User`.`ipaddress`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`gender`, `Profile`.`dob`, `Profile`.`location`, `Profile`.`bio` FROM `db52704_favorr`.`users` AS `User` LEFT JOIN `db52704_favorr`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`username` = &#039;testperson&#039; LIMIT 1</td><td></td><td style = "text-align: right">1</td><td style = "text-align: right">1</td><td style = "text-align: right">0</td></tr>
  7. <tr><td>3</td><td>SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`status`, `User`.`code`, `User`.`created`, `User`.`lastlogin`, `User`.`ipaddress`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`gender`, `Profile`.`dob`, `Profile`.`location`, `Profile`.`bio` FROM `db52704_favorr`.`users` AS `User` LEFT JOIN `db52704_favorr`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`username` = &#039;testperson&#039; LIMIT 1</td><td></td><td style = "text-align: right">1</td><td style = "text-align: right">1</td><td style = "text-align: right">0</td></tr>
  8. <tr><td>4</td><td>SELECT `Profile`.`id`, `Profile`.`user_id`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`gender`, `Profile`.`dob`, `Profile`.`location`, `Profile`.`bio` FROM `db52704_favorr`.`profiles` AS `Profile` WHERE `Profile`.`user_id` = 8 </td><td></td><td style = "text-align: right">1</td><td style = "text-align: right">1</td><td style = "text-align: right">0</td></tr>
  9. <tr><td>5</td><td>SELECT `Friend`.`id`, `Friend`.`username`, `Friend`.`password`, `Friend`.`email`, `Friend`.`phone`, `Friend`.`status`, `Friend`.`code`, `Friend`.`created`, `Friend`.`lastlogin`, `Friend`.`ipaddress`, `FriendsUser`.`id`, `FriendsUser`.`user_id`, `FriendsUser`.`friend_id`, `FriendsUser`.`created`, `FriendsUser`.`status` FROM `db52704_favorr`.`users` AS `Friend` JOIN `db52704_favorr`.`friends_users` AS `FriendsUser` ON (`FriendsUser`.`user_id` = 8 AND `FriendsUser`.`friend_id` = `Friend`.`id`) WHERE `FriendsUser`.`status` = 1 </td><td></td><td style = "text-align: right">0</td><td style = "text-align: right">0</td><td style = "text-align: right">0</td></tr>
  10. <tr><td>6</td><td>SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`status`, `User`.`code`, `User`.`created`, `User`.`lastlogin`, `User`.`ipaddress`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`gender`, `Profile`.`dob`, `Profile`.`location`, `Profile`.`bio` FROM `db52704_favorr`.`users` AS `User` LEFT JOIN `db52704_favorr`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 6 LIMIT 1</td><td></td><td style = "text-align: right">1</td><td style = "text-align: right">1</td><td style = "text-align: right">0</td></tr>
  11. </tbody></table>
Advertisement
Add Comment
Please, Sign In to add comment