My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

RLa

By: a guest | Mar 21st, 2010 | Syntax: SQL | Size: 0.89 KB | Hits: 50 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. 20:37:15.212168         trace   system.db.CDbCommand   
  2.  
  3. Querying SQL: SELECT COUNT(DISTINCT `t`.`id`) FROM `projects` `t`  LEFT
  4. OUTER JOIN `members` `people_people` ON
  5. (`t`.`id`=`people_people`.`project_id`) LEFT OUTER JOIN `users` `people` ON
  6. (`people`.`id`=`people_people`.`user_id`) WHERE (user_id=3)
  7.  
  8. 20:37:15.213573         trace   system.db.ar.CActiveRecord      
  9.  
  10. Project.findAll() eagerly
  11.  
  12. 20:37:15.213686         trace   system.db.CDbCommand    
  13.  
  14. Querying SQL: SELECT `t`.`name` AS `t0_c1`, `t`.`id` AS `t0_c0` FROM
  15. `projects` `t`  LIMIT 10
  16.  
  17. 20:37:15.214778         trace   system.db.CDbCommand    
  18.  
  19. Querying SQL: SELECT `t`.`id` AS `t0_c0`, `people`.`id` AS `t1_c0` FROM
  20. `projects` `t` LEFT OUTER JOIN `members` `people_people` ON
  21. (`t`.`id`=`people_people`.`project_id`) LEFT OUTER JOIN `users` `people` ON
  22. (`people`.`id`=`people_people`.`user_id`) WHERE (`t`.`id` IN (1, 2, 3, 5,
  23. 6, 7, 8, 9, 11, 12)) AND (user_id=3)
create new paste | create new version of this paste RAW Paste Data