Array
(
[0] => Array
(
[News] => Array
(
[id] => 1
[title] => news 1
[category_id] => 0
[keywords] => news 1 key
[description] => news 1 description
[user_id] => 1
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 1
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 1
)
[User] => Array
(
[id] => 1
[first_name] => vasna
[last_name] => sdoeung
[user] => admin
[password] => 1ece51e6676e5c3804448616a4507e52fb43a984
[category_id] => 0
[related_user_id] => 0
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 0
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 0
)
[Created] => Array
(
[id] => 1
[first_name] => vasna
[last_name] => sdoeung
[user] => admin
[password] => 1ece51e6676e5c3804448616a4507e52fb43a984
[category_id] => 0
[related_user_id] => 0
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 0
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 0
)
[Modified] => Array
(
[id] => 1
[first_name] => vasna
[last_name] => sdoeung
[user] => admin
[password] => 1ece51e6676e5c3804448616a4507e52fb43a984
[category_id] => 0
[related_user_id] => 0
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 0
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 0
)
)
[1] => Array
(
[News] => Array
(
[id] => 2
[title] => news 2
[category_id] => 0
[keywords] => news 2 keywords
[description] => news 2 description
[user_id] => 1
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 1
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 1
)
[User] => Array
(
[id] => 1
[first_name] => vasna
[last_name] => sdoeung
[user] => admin
[password] => 1ece51e6676e5c3804448616a4507e52fb43a984
[category_id] => 0
[related_user_id] => 0
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 0
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 0
)
[Created] => Array
(
[id] => 1
[first_name] => vasna
[last_name] => sdoeung
[user] => admin
[password] => 1ece51e6676e5c3804448616a4507e52fb43a984
[category_id] => 0
[related_user_id] => 0
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 0
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 0
)
[Modified] => Array
(
[id] => 1
[first_name] => vasna
[last_name] => sdoeung
[user] => admin
[password] => 1ece51e6676e5c3804448616a4507e52fb43a984
[category_id] => 0
[related_user_id] => 0
[created] => 0000-00-00 00:00:00
[created_by_user_id] => 0
[modified] => 0000-00-00 00:00:00
[modified_by_user_id] => 0
)
)
)
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `news` | 10 | 10 | 31 | |
| 2 | DESCRIBE `users` | 11 | 11 | 2 | |
| 3 | SELECT `News`.`id`, `News`.`title`, `News`.`category_id`, `News`.`keywords`, `News`.`description`, `News`.`user_id`, `News`.`created`, `News`.`created_by_user_id`, `News`.`modified`, `News`.`modified_by_user_id`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`user`, `User`.`password`, `User`.`category_id`, `User`.`related_user_id`, `User`.`created`, `User`.`created_by_user_id`, `User`.`modified`, `User`.`modified_by_user_id`, `Created`.`id`, `Created`.`first_name`, `Created`.`last_name`, `Created`.`user`, `Created`.`password`, `Created`.`category_id`, `Created`.`related_user_id`, `Created`.`created`, `Created`.`created_by_user_id`, `Created`.`modified`, `Created`.`modified_by_user_id`, `Modified`.`id`, `Modified`.`first_name`, `Modified`.`last_name`, `Modified`.`user`, `Modified`.`password`, `Modified`.`category_id`, `Modified`.`related_user_id`, `Modified`.`created`, `Modified`.`created_by_user_id`, `Modified`.`modified`, `Modified`.`modified_by_user_id` FROM `news` AS `News` LEFT JOIN `users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Created` ON (`News`.`created_by_user_id` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`News`.`modified_by_user_id` = `Modified`.`id`) WHERE 1 = 1 | 2 | 2 | 16 |
