SELECT `pictures`.`add_admin_id` AS `add_admin_id` /* int */ ,
UNIX_TIMESTAMP(`pictures`.`add_date`) AS `add_date` /* datetime */,
`pictures`.`edit_admin_id` AS `edit_admin_id` /* int */ ,
UNIX_TIMESTAMP(`pictures`.`lastedit_date`) AS `lastedit_date` /* datetime */,
`pictures`.`idob` AS `idob` /* int */ ,
`pictures`.`account_id` AS `account_id` /* int */ ,
`pictures`.`name` AS `name` /* varchar */ ,
`pictures`.`tri` AS `tri` /* int */ ,
`pictures`.`position` AS `position` /* int */ ,
`pictures`.`description` AS `description` /* varchar */ ,
`pictures`.`online` AS `online` /* int */ ,
`pictures`.`home` AS `home` /* int */ ,
`pictures`.`project_presentation` AS `project_presentation` /* int */ ,
`pictures`.`project_construction` AS `project_construction` /* int */ ,
`pictures`.`project_municipality` AS `project_municipality` /* int */ ,
`pictures`.`project_situation` AS `project_situation` /* int */ ,
`pictures`.`project_transport` AS `project_transport` /* int */ ,
`pictures`.`project_leisure` AS `project_leisure` /* int */ ,
`pictures`.`object` AS `object` /* int */ ,
`pictures`.`gallery_online` AS `gallery_online` /* int */ ,
`pictures`.`pdf_online` AS `pdf_online` /* int */ ,
`pictures`.`pdf_internal` AS `pdf_internal` /* int */ ,
`pictures`.`sha1` AS `sha1` /* varchar */ ,
`pictures`.`id` AS `id` /* int */
FROM `pictures` INNER JOIN (`objects` as `objects[object]`) ON ((`objects[object]`.`id` = `pictures`.`idob` AND (1)))
WHERE (`pictures`.`idob` IN ('1679553') /* int */ AND `pictures`.`home` = '1' /* int */)
ORDER BY `objects[object]`.`level` ASC,
`pictures`.`idob` ASC,
`pictures`.`tri` ASC
Time: 0.00137
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
objects[object]
const
PRIMARY
PRIMARY
4
const
1
100.00
Using filesort
1
SIMPLE
pictures
ref
idob
idob
4
const
7
10.00
Using index condition; Using where
SELECT * FROM `languages` ORDER BY `sort`
Time: 0.00019
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
languages
ALL
15
100.00
Using filesort
SELECT `languages`.`lang` AS `lang` /* unknown */ ,
`languages`.`bitmask` AS `bitmask` /* int */ ,
`languages`.`sort` AS `sort` /* int */ ,
`languages`.`is_base` AS `is_base` /* enum */ ,
`languages`.`available_frontend` AS `available_frontend` /* enum */ ,
`languages`.`available_backend` AS `available_backend` /* enum */ ,
`languages`.`id` AS `id` /* int */
FROM `languages`
WHERE (`languages`.`lang` = 'fr' /* unknown */)
Time: 0.00020
9 appartements de bon standing, plus que 3 disponibles !
Le coteau de la Laire est un nouveau projet aux lignes contemporaines, implanté dans un environnement verdoyant et au calme absolu, à l'orée des Bois de Chancy.
![[IMG]](http://static1.immomigsa.ch/i/24150/400x300/m/418/pictures/admins/admin_7916_5c092173f06504.34703447.jpg)