Notice: Undefined variable: h2 in /home/relphy/public_html/app/views/persons/index.php on line 44
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COUNT(*) AS `count` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Obj`.`id` != '' AND 1 | 1 | 1 | 0 | |
| 2 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Obj`.`id` != '' AND 1 ORDER BY `Person`.`id` DESC LIMIT 15 | 15 | 15 | 0 | |
| 3 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 80 LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 78 LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 77 LIMIT 1 | 1 | 1 | 0 | |
| 6 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 76 LIMIT 1 | 1 | 1 | 0 | |
| 7 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 74 LIMIT 1 | 1 | 1 | 0 | |
| 8 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 73 LIMIT 1 | 1 | 1 | 0 | |
| 9 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 72 LIMIT 1 | 1 | 1 | 0 | |
| 10 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 71 LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 70 LIMIT 1 | 1 | 1 | 0 | |
| 12 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 69 LIMIT 1 | 1 | 1 | 0 | |
| 13 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 68 LIMIT 1 | 1 | 1 | 0 | |
| 14 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 67 LIMIT 1 | 1 | 1 | 0 | |
| 15 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 66 LIMIT 1 | 1 | 1 | 0 | |
| 16 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 65 LIMIT 1 | 1 | 1 | 0 | |
| 17 | SELECT `Person`.`id`, `Person`.`forename`, `Person`.`surname`, `Person`.`gender`, `Person`.`date_of_birth`, `Person`.`photo`, `Person`.`description`, `Person`.`obj_id`, `Person`.`user_id`, `Person`.`title`, `Person`.`country_id`, `Obj`.`id`, `Obj`.`created`, `Obj`.`modified`, `Obj`.`type` FROM `people` AS `Person` LEFT JOIN `objs` AS `Obj` ON (`Obj`.`id` != 0 AND `Person`.`obj_id` = `Obj`.`id`) WHERE `Person`.`id` = 64 LIMIT 1 | 1 | 1 | 0 |