array ( 0 => 1749030, )

 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
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEobjects[object]constPRIMARYPRIMARY4const1100.00Using filesort
1SIMPLEpicturesrefidobidob4const4110.00Using 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
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEremote_files_imagesconstPRIMARYPRIMARY4const1100.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
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEremote_filesconstPRIMARYPRIMARY4const1100.00
Startseite | Fährhof AG Immobilien
ÜberblickÜberblickÜberblickÜberblickÜberblickÜberblickÜberblickÜberblickÜberblickÜberblick

Grosszügige Neubauwohnungen an sonniger Hanglage mit Fernsicht