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`.`mls` AS `mls` /* int */ ,
`pictures`.`sha1` AS `sha1` /* varchar */ ,
`pictures`.`remote_file_id` AS `remote_file_id` /* int/null */ ,
`pictures`.`plan_ordered` AS `plan_ordered` /* unknown */ ,
`pictures`.`inherit` AS `inherit` /* unknown */ ,
`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 ('1749030') /* int */ AND `pictures`.`home` = '1' /* int */)
ORDER BY `objects[object]`.`level` ASC,
`pictures`.`idob` ASC,
`pictures`.`tri` ASC
Time: 0.00141
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
41
10.00
Using index condition; Using where
SELECT `remote_files_images`.`remote_file_id` AS `remote_file_id` /* int */ ,
`remote_files_images`.`width` AS `width` /* int */ ,
`remote_files_images`.`height` AS `height` /* int */
FROM `remote_files_images`
WHERE (`remote_files_images`.`remote_file_id` = '152398' /* int */)
Time: 0.00031
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
remote_files_images
const
PRIMARY
PRIMARY
4
const
1
100.00
SELECT `remote_files`.`id` AS `id` /* int */ ,
`remote_files`.`account_id` AS `account_id` /* int */ ,
`remote_files`.`path` AS `path` /* varchar */ ,
`remote_files`.`filename` AS `filename` /* varchar */ ,
`remote_files`.`sha1` AS `sha1` /* varchar */ ,
`remote_files`.`size` AS `size` /* int */ ,
`remote_files`.`type` AS `type` /* enum */
FROM `remote_files`
WHERE (`remote_files`.`id` = '152398' /* int */)
Time: 0.00027
