| Query |
Affected |
Num. rows |
Took (ms) |
Actions |
| SELECT "Project"."id" AS "Project__id", "Project"."title" AS "Project__title", "Project"."ego" AS "Project__ego", "Project"."facebook" AS "Project__facebook", "Project"."twitter" AS "Project__twitter", "Project"."pinterest" AS "Project__pinterest", "Project"."active" AS "Project__active", "Project"."user_id" AS "Project__user_id", "Project"."google_analytics" AS "Project__google_analytics" FROM "public"."projects" AS "Project" WHERE "Project"."dominio_unico" LIKE '%phottic.com%' LIMIT 1 |
0 |
0 |
2 |
maybe slow
|
| SELECT "Photo"."id" AS "Photo__id", "Photo"."copyright_id" AS "Photo__copyright_id", "Photo"."title" AS "Photo__title", "Photo"."description" AS "Photo__description", "Photo"."date_first_published" AS "Photo__date_first_published", "Photo"."real_year" AS "Photo__real_year", "Photo"."is_googlemaps" AS "Photo__is_googlemaps", "Photo"."is_streetview" AS "Photo__is_streetview", "Photo"."photo_ratio" AS "Photo__photo_ratio", "Photo"."status" AS "Photo__status", "Photo"."last_revised_user" AS "Photo__last_revised_user", "Photo"."date_last_revised" AS "Photo__date_last_revised", "Photo"."visits" AS "Photo__visits", "Photo"."error_year" AS "Photo__error_year", "Photo"."location_id" AS "Photo__location_id", "Photo"."original_filename" AS "Photo__original_filename", "Photo"."original_size" AS "Photo__original_size", "Photo"."extension" AS "Photo__extension", "Photo"."mime_type" AS "Photo__mime_type", "Photo"."user_id" AS "Photo__user_id", "Photo"."created" AS "Photo__created", "Photo"."modified" AS "Photo__modified", "Photo"."path_image" AS "Photo__path_image", "Photo"."id_old" AS "Photo__id_old", "Photo"."deleted" AS "Photo__deleted", "Photo"."image_position_top" AS "Photo__image_position_top", "Photo"."image_position_left" AS "Photo__image_position_left", "Photo"."image_width" AS "Photo__image_width", "Photo"."image_height" AS "Photo__image_height", "Photo"."process" AS "Photo__process", "Photo"."sell" AS "Photo__sell", "Photo"."real_date" AS "Photo__real_date", "Photo"."apikey_id" AS "Photo__apikey_id", "Photo"."contract_id" AS "Photo__contract_id" FROM "public"."photos" AS "Photo" WHERE "Photo"."id" = 254 LIMIT 1 |
1 |
1 |
3 |
maybe slow
|
| SELECT "Projects"."id" AS "Projects__id", "Projects"."title" AS "Projects__title", "Projects"."description" AS "Projects__description", "Projects"."image" AS "Projects__image", "Projects"."active" AS "Projects__active", "Projects"."setting_id" AS "Projects__setting_id", "Projects"."created" AS "Projects__created", "Projects"."view_home" AS "Projects__view_home", "Projects"."user_id" AS "Projects__user_id", "Projects"."ego" AS "Projects__ego", "Projects"."address" AS "Projects__address", "Projects"."phone" AS "Projects__phone", "Projects"."email" AS "Projects__email", "Projects"."facebook" AS "Projects__facebook", "Projects"."twitter" AS "Projects__twitter", "Projects"."pinterest" AS "Projects__pinterest", "Projects"."dominio_unico" AS "Projects__dominio_unico", "Projects"."type" AS "Projects__type", "Projects"."comments_type" AS "Projects__comments_type", "Projects"."country_code" AS "Projects__country_code", "Projects"."country" AS "Projects__country", "Projects"."publish_type" AS "Projects__publish_type", "Projects"."seo" AS "Projects__seo", "Projects"."watermark" AS "Projects__watermark", "Projects"."google_analytics" AS "Projects__google_analytics", "Projects"."singular_landing_layout" AS "Projects__singular_landing_layout", "Projects"."singular_landing_view" AS "Projects__singular_landing_view", "ProjectsAlbumsPhoto"."id" AS "ProjectsAlbumsPhoto__id", "ProjectsAlbumsPhoto"."project_id" AS "ProjectsAlbumsPhoto__project_id", "ProjectsAlbumsPhoto"."photo_id" AS "ProjectsAlbumsPhoto__photo_id", "ProjectsAlbumsPhoto"."created" AS "ProjectsAlbumsPhoto__created", "ProjectsAlbumsPhoto"."id_photo_old" AS "ProjectsAlbumsPhoto__id_photo_old", "ProjectsAlbumsPhoto"."album_id" AS "ProjectsAlbumsPhoto__album_id" FROM "public"."projects" AS "Projects" JOIN "public"."projects_albums_photos" AS "ProjectsAlbumsPhoto" ON ("ProjectsAlbumsPhoto"."photo_id" = 254 AND "ProjectsAlbumsPhoto"."project_id" = "Projects"."id") |
1 |
1 |
5 |
maybe slow
|
| SELECT "Photo"."id" AS "Photo__id", "Photo"."copyright_id" AS "Photo__copyright_id", "Photo"."title" AS "Photo__title", "Photo"."description" AS "Photo__description", "Photo"."date_first_published" AS "Photo__date_first_published", "Photo"."real_year" AS "Photo__real_year", "Photo"."is_googlemaps" AS "Photo__is_googlemaps", "Photo"."is_streetview" AS "Photo__is_streetview", "Photo"."photo_ratio" AS "Photo__photo_ratio", "Photo"."status" AS "Photo__status", "Photo"."last_revised_user" AS "Photo__last_revised_user", "Photo"."date_last_revised" AS "Photo__date_last_revised", "Photo"."visits" AS "Photo__visits", "Photo"."error_year" AS "Photo__error_year", "Photo"."location_id" AS "Photo__location_id", "Photo"."original_filename" AS "Photo__original_filename", "Photo"."original_size" AS "Photo__original_size", "Photo"."extension" AS "Photo__extension", "Photo"."mime_type" AS "Photo__mime_type", "Photo"."user_id" AS "Photo__user_id", "Photo"."created" AS "Photo__created", "Photo"."modified" AS "Photo__modified", "Photo"."path_image" AS "Photo__path_image", "Photo"."id_old" AS "Photo__id_old", "Photo"."deleted" AS "Photo__deleted", "Photo"."image_position_top" AS "Photo__image_position_top", "Photo"."image_position_left" AS "Photo__image_position_left", "Photo"."image_width" AS "Photo__image_width", "Photo"."image_height" AS "Photo__image_height", "Photo"."process" AS "Photo__process", "Photo"."sell" AS "Photo__sell", "Photo"."real_date" AS "Photo__real_date", "Photo"."apikey_id" AS "Photo__apikey_id", "Photo"."contract_id" AS "Photo__contract_id", "Copyright"."id" AS "Copyright__id", "Copyright"."name" AS "Copyright__name", "Copyright"."active" AS "Copyright__active", "Copyright"."id_old" AS "Copyright__id_old", "Location"."id" AS "Location__id", "Location"."photo_id" AS "Location__photo_id", "Location"."latitude" AS "Location__latitude", "Location"."longitude" AS "Location__longitude", "Location"."formatted_address" AS "Location__formatted_address", "Location"."map_zoom" AS "Location__map_zoom", "Location"."panorama_zoom" AS "Location__panorama_zoom", "Location"."country" AS "Location__country", "Location"."region" AS "Location__region", "Location"."province" AS "Location__province", "Location"."locality" AS "Location__locality", "Location"."heading" AS "Location__heading", "Location"."pitch" AS "Location__pitch", "Location"."photo_id_old" AS "Location__photo_id_old", "Location"."percent_top" AS "Location__percent_top", "Location"."percent_left" AS "Location__percent_left", "Location"."crop_width" AS "Location__crop_width", "Location"."crop_height" AS "Location__crop_height", "Location"."ratio" AS "Location__ratio", "Location"."street_zoom" AS "Location__street_zoom", "Location"."street_opacity" AS "Location__street_opacity", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."id" AS "User__id", "User"."group_id" AS "User__group_id", "User"."born_year" AS "User__born_year", "User"."active" AS "User__active", "User"."token" AS "User__token", "User"."avatar" AS "User__avatar", "User"."date_activation" AS "User__date_activation", "User"."type_avatar" AS "User__type_avatar", "User"."email" AS "User__email", "User"."name" AS "User__name", "User"."lat" AS "User__lat", "User"."lon" AS "User__lon", "User"."description" AS "User__description", "User"."app_type" AS "User__app_type", "User"."account_type" AS "User__account_type", "User"."id_old" AS "User__id_old", "User"."old" AS "User__old", "User"."gender" AS "User__gender", "User"."locale" AS "User__locale", "User"."social_link" AS "User__social_link", "User"."social_id" AS "User__social_id", "User"."sell_photo" AS "User__sell_photo", "User"."project_id" AS "User__project_id", "User"."last_view_activity" AS "User__last_view_activity", "User"."show_welcome" AS "User__show_welcome" FROM "public"."photos" AS "Photo" LEFT JOIN "public"."copyrights" AS "Copyright" ON ("Photo"."copyright_id" = "Copyright"."id") LEFT JOIN "public"."locations" AS "Location" ON ("Photo"."location_id" = "Location"."id") LEFT JOIN "public"."users" AS "User" ON ("Photo"."user_id" = "User"."id") WHERE "Photo"."id" = 254 AND "Photo"."deleted" = 'FALSE' LIMIT 1 |
1 |
1 |
4 |
maybe slow
|
| SELECT "Comment"."id" AS "Comment__id", "Comment"."photo_id" AS "Comment__photo_id", "Comment"."user_id" AS "Comment__user_id", "Comment"."comment" AS "Comment__comment", "Comment"."status" AS "Comment__status", "Comment"."date_published" AS "Comment__date_published", "Comment"."comment_id" AS "Comment__comment_id", "Comment"."created" AS "Comment__created", "Comment"."id_photo_old" AS "Comment__id_photo_old", "Comment"."new_import" AS "Comment__new_import" FROM "public"."comments" AS "Comment" WHERE "Comment"."status" = 1 AND "Comment"."photo_id" = (254) |
0 |
0 |
4 |
maybe slow
|
| SELECT "Ratings"."id" AS "Ratings__id", "Ratings"."photo_id" AS "Ratings__photo_id", "Ratings"."user_id" AS "Ratings__user_id", "Ratings"."created" AS "Ratings__created", "Ratings"."modified" AS "Ratings__modified", "Ratings"."id_photo_old" AS "Ratings__id_photo_old" FROM "public"."ratings" AS "Ratings" WHERE "Ratings"."photo_id" = (254) |
0 |
0 |
2 |
maybe slow
|
| SELECT "Tags"."id" AS "Tags__id", "Tags"."title" AS "Tags__title", "Tags"."created" AS "Tags__created", "PhotosTag"."id" AS "PhotosTag__id", "PhotosTag"."photo_id" AS "PhotosTag__photo_id", "PhotosTag"."tag_id" AS "PhotosTag__tag_id", "PhotosTag"."created" AS "PhotosTag__created", "PhotosTag"."id_photo_old" AS "PhotosTag__id_photo_old" FROM "public"."tags" AS "Tags" JOIN "public"."photos_tags" AS "PhotosTag" ON ("PhotosTag"."photo_id" = 254 AND "PhotosTag"."tag_id" = "Tags"."id") |
1 |
1 |
4 |
maybe slow
|
| SELECT "Albums"."id" AS "Albums__id", "Albums"."created" AS "Albums__created", "Albums"."modified" AS "Albums__modified", "Albums"."title" AS "Albums__title", "Albums"."description" AS "Albums__description", "Albums"."image" AS "Albums__image", "Albums"."project_id" AS "Albums__project_id", "Albums"."id_old" AS "Albums__id_old", "Albums"."published" AS "Albums__published", "Albums"."user_id" AS "Albums__user_id", "ProjectsAlbumsPhoto"."id" AS "ProjectsAlbumsPhoto__id", "ProjectsAlbumsPhoto"."project_id" AS "ProjectsAlbumsPhoto__project_id", "ProjectsAlbumsPhoto"."photo_id" AS "ProjectsAlbumsPhoto__photo_id", "ProjectsAlbumsPhoto"."created" AS "ProjectsAlbumsPhoto__created", "ProjectsAlbumsPhoto"."id_photo_old" AS "ProjectsAlbumsPhoto__id_photo_old", "ProjectsAlbumsPhoto"."album_id" AS "ProjectsAlbumsPhoto__album_id" FROM "public"."albums" AS "Albums" JOIN "public"."projects_albums_photos" AS "ProjectsAlbumsPhoto" ON ("ProjectsAlbumsPhoto"."photo_id" = 254 AND "ProjectsAlbumsPhoto"."album_id" = "Albums"."id") |
1 |
1 |
5 |
maybe slow
|
| SELECT "Projects"."id" AS "Projects__id", "Projects"."title" AS "Projects__title", "Projects"."description" AS "Projects__description", "Projects"."image" AS "Projects__image", "Projects"."active" AS "Projects__active", "Projects"."setting_id" AS "Projects__setting_id", "Projects"."created" AS "Projects__created", "Projects"."view_home" AS "Projects__view_home", "Projects"."user_id" AS "Projects__user_id", "Projects"."ego" AS "Projects__ego", "Projects"."address" AS "Projects__address", "Projects"."phone" AS "Projects__phone", "Projects"."email" AS "Projects__email", "Projects"."facebook" AS "Projects__facebook", "Projects"."twitter" AS "Projects__twitter", "Projects"."pinterest" AS "Projects__pinterest", "Projects"."dominio_unico" AS "Projects__dominio_unico", "Projects"."type" AS "Projects__type", "Projects"."comments_type" AS "Projects__comments_type", "Projects"."country_code" AS "Projects__country_code", "Projects"."country" AS "Projects__country", "Projects"."publish_type" AS "Projects__publish_type", "Projects"."seo" AS "Projects__seo", "Projects"."watermark" AS "Projects__watermark", "Projects"."google_analytics" AS "Projects__google_analytics", "Projects"."singular_landing_layout" AS "Projects__singular_landing_layout", "Projects"."singular_landing_view" AS "Projects__singular_landing_view", "ProjectsAlbumsPhoto"."id" AS "ProjectsAlbumsPhoto__id", "ProjectsAlbumsPhoto"."project_id" AS "ProjectsAlbumsPhoto__project_id", "ProjectsAlbumsPhoto"."photo_id" AS "ProjectsAlbumsPhoto__photo_id", "ProjectsAlbumsPhoto"."created" AS "ProjectsAlbumsPhoto__created", "ProjectsAlbumsPhoto"."id_photo_old" AS "ProjectsAlbumsPhoto__id_photo_old", "ProjectsAlbumsPhoto"."album_id" AS "ProjectsAlbumsPhoto__album_id" FROM "public"."projects" AS "Projects" JOIN "public"."projects_albums_photos" AS "ProjectsAlbumsPhoto" ON ("ProjectsAlbumsPhoto"."photo_id" = 254 AND "ProjectsAlbumsPhoto"."project_id" = "Projects"."id") |
1 |
1 |
5 |
maybe slow
|
| SELECT "ProjectAlbumPhoto"."id" AS "ProjectAlbumPhoto__id", "ProjectAlbumPhoto"."project_id" AS "ProjectAlbumPhoto__project_id", "ProjectAlbumPhoto"."photo_id" AS "ProjectAlbumPhoto__photo_id", "ProjectAlbumPhoto"."created" AS "ProjectAlbumPhoto__created", "ProjectAlbumPhoto"."id_photo_old" AS "ProjectAlbumPhoto__id_photo_old", "ProjectAlbumPhoto"."album_id" AS "ProjectAlbumPhoto__album_id" FROM "public"."projects_albums_photos" AS "ProjectAlbumPhoto" INNER JOIN "public"."photos" AS "Photo" ON ("Photo"."id" = "ProjectAlbumPhoto"."photo_id") WHERE "ProjectAlbumPhoto"."project_id" = 6 AND "Photo"."status" = 2 AND "Photo"."deleted" = 'FALSE' |
3721 |
3721 |
35 |
|
| SELECT "Photo"."id" AS "Photo__id" FROM "public"."photos" AS "Photo" INNER JOIN "public"."projects_albums_photos" AS "ProjectAlbumPhoto" ON ("Photo"."id" = "ProjectAlbumPhoto"."photo_id") LEFT JOIN "public"."projects" AS "Project" ON ("Project"."id" = "ProjectAlbumPhoto"."project_id") WHERE "ProjectAlbumPhoto"."project_id" = 6 AND "Photo"."id" <> 254 AND "Photo"."status" = 2 AND "Photo"."deleted" = 'FALSE' AND "Photo"."created" >= '2013-04-20 23:06:38' AND (("Project"."active" = 'TRUE') OR ("Project"."active" IS NULL)) ORDER BY "Photo"."created" asc LIMIT 1 |
1 |
1 |
22 |
maybe slow
|
| SELECT "Photo"."id" AS "Photo__id" FROM "public"."photos" AS "Photo" LEFT JOIN "public"."copyrights" AS "Copyright" ON ("Photo"."copyright_id" = "Copyright"."id") LEFT JOIN "public"."locations" AS "Location" ON ("Photo"."location_id" = "Location"."id") LEFT JOIN "public"."users" AS "User" ON ("Photo"."user_id" = "User"."id") INNER JOIN "public"."projects_albums_photos" AS "ProjectAlbumPhoto" ON ("Photo"."id" = "ProjectAlbumPhoto"."photo_id") LEFT JOIN "public"."projects" AS "Project" ON ("Project"."id" = "ProjectAlbumPhoto"."project_id") WHERE "ProjectAlbumPhoto"."project_id" = 6 AND "Photo"."id" <> 254 AND "Photo"."status" = 2 AND "Photo"."deleted" = 'FALSE' AND "Photo"."created" <= '2013-04-20 23:06:38' AND (("Project"."active" = 'TRUE') OR ("Project"."active" IS NULL)) ORDER BY "Photo"."created" desc LIMIT 1 |
1 |
1 |
16 |
maybe slow
|
| SELECT "Comment"."id" AS "Comment__id", "Comment"."photo_id" AS "Comment__photo_id", "Comment"."user_id" AS "Comment__user_id", "Comment"."comment" AS "Comment__comment", "Comment"."status" AS "Comment__status", "Comment"."date_published" AS "Comment__date_published", "Comment"."comment_id" AS "Comment__comment_id", "Comment"."created" AS "Comment__created", "Comment"."id_photo_old" AS "Comment__id_photo_old", "Comment"."new_import" AS "Comment__new_import" FROM "public"."comments" AS "Comment" WHERE "Comment"."status" = 1 AND "Comment"."photo_id" = (253) |
0 |
0 |
4 |
maybe slow
|
| SELECT "Ratings"."id" AS "Ratings__id", "Ratings"."photo_id" AS "Ratings__photo_id", "Ratings"."user_id" AS "Ratings__user_id", "Ratings"."created" AS "Ratings__created", "Ratings"."modified" AS "Ratings__modified", "Ratings"."id_photo_old" AS "Ratings__id_photo_old" FROM "public"."ratings" AS "Ratings" WHERE "Ratings"."photo_id" = (253) |
0 |
0 |
2 |
maybe slow
|
| SELECT "Tags"."id" AS "Tags__id", "Tags"."title" AS "Tags__title", "Tags"."created" AS "Tags__created", "PhotosTag"."id" AS "PhotosTag__id", "PhotosTag"."photo_id" AS "PhotosTag__photo_id", "PhotosTag"."tag_id" AS "PhotosTag__tag_id", "PhotosTag"."created" AS "PhotosTag__created", "PhotosTag"."id_photo_old" AS "PhotosTag__id_photo_old" FROM "public"."tags" AS "Tags" JOIN "public"."photos_tags" AS "PhotosTag" ON ("PhotosTag"."photo_id" = 253 AND "PhotosTag"."tag_id" = "Tags"."id") |
1 |
1 |
4 |
maybe slow
|
| SELECT "Albums"."id" AS "Albums__id", "Albums"."created" AS "Albums__created", "Albums"."modified" AS "Albums__modified", "Albums"."title" AS "Albums__title", "Albums"."description" AS "Albums__description", "Albums"."image" AS "Albums__image", "Albums"."project_id" AS "Albums__project_id", "Albums"."id_old" AS "Albums__id_old", "Albums"."published" AS "Albums__published", "Albums"."user_id" AS "Albums__user_id", "ProjectsAlbumsPhoto"."id" AS "ProjectsAlbumsPhoto__id", "ProjectsAlbumsPhoto"."project_id" AS "ProjectsAlbumsPhoto__project_id", "ProjectsAlbumsPhoto"."photo_id" AS "ProjectsAlbumsPhoto__photo_id", "ProjectsAlbumsPhoto"."created" AS "ProjectsAlbumsPhoto__created", "ProjectsAlbumsPhoto"."id_photo_old" AS "ProjectsAlbumsPhoto__id_photo_old", "ProjectsAlbumsPhoto"."album_id" AS "ProjectsAlbumsPhoto__album_id" FROM "public"."albums" AS "Albums" JOIN "public"."projects_albums_photos" AS "ProjectsAlbumsPhoto" ON ("ProjectsAlbumsPhoto"."photo_id" = 253 AND "ProjectsAlbumsPhoto"."album_id" = "Albums"."id") |
1 |
1 |
7 |
maybe slow
|
| SELECT "Projects"."id" AS "Projects__id", "Projects"."title" AS "Projects__title", "Projects"."description" AS "Projects__description", "Projects"."image" AS "Projects__image", "Projects"."active" AS "Projects__active", "Projects"."setting_id" AS "Projects__setting_id", "Projects"."created" AS "Projects__created", "Projects"."view_home" AS "Projects__view_home", "Projects"."user_id" AS "Projects__user_id", "Projects"."ego" AS "Projects__ego", "Projects"."address" AS "Projects__address", "Projects"."phone" AS "Projects__phone", "Projects"."email" AS "Projects__email", "Projects"."facebook" AS "Projects__facebook", "Projects"."twitter" AS "Projects__twitter", "Projects"."pinterest" AS "Projects__pinterest", "Projects"."dominio_unico" AS "Projects__dominio_unico", "Projects"."type" AS "Projects__type", "Projects"."comments_type" AS "Projects__comments_type", "Projects"."country_code" AS "Projects__country_code", "Projects"."country" AS "Projects__country", "Projects"."publish_type" AS "Projects__publish_type", "Projects"."seo" AS "Projects__seo", "Projects"."watermark" AS "Projects__watermark", "Projects"."google_analytics" AS "Projects__google_analytics", "Projects"."singular_landing_layout" AS "Projects__singular_landing_layout", "Projects"."singular_landing_view" AS "Projects__singular_landing_view", "ProjectsAlbumsPhoto"."id" AS "ProjectsAlbumsPhoto__id", "ProjectsAlbumsPhoto"."project_id" AS "ProjectsAlbumsPhoto__project_id", "ProjectsAlbumsPhoto"."photo_id" AS "ProjectsAlbumsPhoto__photo_id", "ProjectsAlbumsPhoto"."created" AS "ProjectsAlbumsPhoto__created", "ProjectsAlbumsPhoto"."id_photo_old" AS "ProjectsAlbumsPhoto__id_photo_old", "ProjectsAlbumsPhoto"."album_id" AS "ProjectsAlbumsPhoto__album_id" FROM "public"."projects" AS "Projects" JOIN "public"."projects_albums_photos" AS "ProjectsAlbumsPhoto" ON ("ProjectsAlbumsPhoto"."photo_id" = 253 AND "ProjectsAlbumsPhoto"."project_id" = "Projects"."id") |
1 |
1 |
6 |
maybe slow
|
| SELECT "Photo"."id" AS "Photo__id", "Photo"."title" AS "Photo__title", "Photo"."photo_ratio" AS "Photo__photo_ratio", "Photo"."visits" AS "Photo__visits", "Photo"."original_filename" AS "Photo__original_filename", "Photo"."original_size" AS "Photo__original_size", "Photo"."extension" AS "Photo__extension", "Photo"."path_image" AS "Photo__path_image" FROM "public"."photos" AS "Photo" LEFT JOIN "public"."projects_albums_photos" AS "ProjectAlbumPhoto" ON ("Photo"."id" = "ProjectAlbumPhoto"."photo_id") LEFT JOIN "public"."projects" AS "Project" ON ("Project"."id" = "ProjectAlbumPhoto"."project_id") WHERE "Photo"."id" <> 254 AND "Photo"."status" = 2 AND "Photo"."deleted" = 'FALSE' AND "Photo"."user_id" = 239 AND (("Project"."active" = 'TRUE') OR ("Project"."active" IS NULL)) ORDER BY random() ASC LIMIT 3 |
3 |
3 |
21 |
maybe slow
|
| SELECT "Photo"."id" AS "Photo__id", "Photo"."title" AS "Photo__title", "Photo"."photo_ratio" AS "Photo__photo_ratio", "Photo"."visits" AS "Photo__visits", "Photo"."original_filename" AS "Photo__original_filename", "Photo"."original_size" AS "Photo__original_size", "Photo"."extension" AS "Photo__extension", "Photo"."path_image" AS "Photo__path_image" FROM "public"."photos" AS "Photo" LEFT JOIN "public"."projects_albums_photos" AS "ProjectAlbumPhoto" ON ("Photo"."id" = "ProjectAlbumPhoto"."photo_id") LEFT JOIN "public"."projects" AS "Project" ON ("Project"."id" = "ProjectAlbumPhoto"."project_id") WHERE "ProjectAlbumPhoto"."project_id" = 6 AND "ProjectAlbumPhoto"."photo_id" <> '254' AND "Photo"."status" = 2 AND "Photo"."deleted" = 'FALSE' AND (("Project"."active" = 'TRUE') OR ("Project"."active" IS NULL)) ORDER BY random() ASC LIMIT 9 |
9 |
9 |
22 |
maybe slow
|
| SELECT "Comment"."id" AS "Comment__id", "Comment"."photo_id" AS "Comment__photo_id", "Comment"."user_id" AS "Comment__user_id", "Comment"."comment" AS "Comment__comment", "Comment"."status" AS "Comment__status", "Comment"."date_published" AS "Comment__date_published", "Comment"."comment_id" AS "Comment__comment_id", "Comment"."created" AS "Comment__created", "Comment"."id_photo_old" AS "Comment__id_photo_old", "Comment"."new_import" AS "Comment__new_import", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."id" AS "User__id", "User"."group_id" AS "User__group_id", "User"."born_year" AS "User__born_year", "User"."active" AS "User__active", "User"."token" AS "User__token", "User"."avatar" AS "User__avatar", "User"."date_activation" AS "User__date_activation", "User"."type_avatar" AS "User__type_avatar", "User"."email" AS "User__email", "User"."name" AS "User__name", "User"."lat" AS "User__lat", "User"."lon" AS "User__lon", "User"."description" AS "User__description", "User"."app_type" AS "User__app_type", "User"."account_type" AS "User__account_type", "User"."id_old" AS "User__id_old", "User"."old" AS "User__old", "User"."gender" AS "User__gender", "User"."locale" AS "User__locale", "User"."social_link" AS "User__social_link", "User"."social_id" AS "User__social_id", "User"."sell_photo" AS "User__sell_photo", "User"."project_id" AS "User__project_id", "User"."last_view_activity" AS "User__last_view_activity", "User"."show_welcome" AS "User__show_welcome", "Photo"."id" AS "Photo__id", "Photo"."copyright_id" AS "Photo__copyright_id", "Photo"."title" AS "Photo__title", "Photo"."description" AS "Photo__description", "Photo"."date_first_published" AS "Photo__date_first_published", "Photo"."real_year" AS "Photo__real_year", "Photo"."is_googlemaps" AS "Photo__is_googlemaps", "Photo"."is_streetview" AS "Photo__is_streetview", "Photo"."photo_ratio" AS "Photo__photo_ratio", "Photo"."status" AS "Photo__status", "Photo"."last_revised_user" AS "Photo__last_revised_user", "Photo"."date_last_revised" AS "Photo__date_last_revised", "Photo"."visits" AS "Photo__visits", "Photo"."error_year" AS "Photo__error_year", "Photo"."location_id" AS "Photo__location_id", "Photo"."original_filename" AS "Photo__original_filename", "Photo"."original_size" AS "Photo__original_size", "Photo"."extension" AS "Photo__extension", "Photo"."mime_type" AS "Photo__mime_type", "Photo"."user_id" AS "Photo__user_id", "Photo"."created" AS "Photo__created", "Photo"."modified" AS "Photo__modified", "Photo"."path_image" AS "Photo__path_image", "Photo"."id_old" AS "Photo__id_old", "Photo"."deleted" AS "Photo__deleted", "Photo"."image_position_top" AS "Photo__image_position_top", "Photo"."image_position_left" AS "Photo__image_position_left", "Photo"."image_width" AS "Photo__image_width", "Photo"."image_height" AS "Photo__image_height", "Photo"."process" AS "Photo__process", "Photo"."sell" AS "Photo__sell", "Photo"."real_date" AS "Photo__real_date", "Photo"."apikey_id" AS "Photo__apikey_id", "Photo"."contract_id" AS "Photo__contract_id" FROM "public"."comments" AS "Comment" LEFT JOIN "public"."users" AS "User" ON ("Comment"."user_id" = "User"."id") LEFT JOIN "public"."photos" AS "Photo" ON ("Comment"."photo_id" = "Photo"."id") WHERE "Comment"."photo_id" = 254 AND "Comment"."status" = 1 ORDER BY "Comment"."date_published" DESC LIMIT 15 |
0 |
0 |
5 |
maybe slow
|
| SELECT "ProjectsUser"."id" AS "ProjectsUser__id", "ProjectsUser"."project_id" AS "ProjectsUser__project_id", "ProjectsUser"."user_id" AS "ProjectsUser__user_id", "ProjectsUser"."created" AS "ProjectsUser__created", "ProjectsUser"."accepted" AS "ProjectsUser__accepted", "ProjectsUser"."state" AS "ProjectsUser__state", "ProjectsUser"."modified" AS "ProjectsUser__modified", "ProjectsUser"."comments_state" AS "ProjectsUser__comments_state", "ProjectsUser"."photos_state" AS "ProjectsUser__photos_state", "Project"."id" AS "Project__id", "Project"."title" AS "Project__title", "Project"."description" AS "Project__description", "Project"."image" AS "Project__image", "Project"."active" AS "Project__active", "Project"."setting_id" AS "Project__setting_id", "Project"."created" AS "Project__created", "Project"."view_home" AS "Project__view_home", "Project"."user_id" AS "Project__user_id", "Project"."ego" AS "Project__ego", "Project"."address" AS "Project__address", "Project"."phone" AS "Project__phone", "Project"."email" AS "Project__email", "Project"."facebook" AS "Project__facebook", "Project"."twitter" AS "Project__twitter", "Project"."pinterest" AS "Project__pinterest", "Project"."dominio_unico" AS "Project__dominio_unico", "Project"."type" AS "Project__type", "Project"."comments_type" AS "Project__comments_type", "Project"."country_code" AS "Project__country_code", "Project"."country" AS "Project__country", "Project"."publish_type" AS "Project__publish_type", "Project"."seo" AS "Project__seo", "Project"."watermark" AS "Project__watermark", "Project"."google_analytics" AS "Project__google_analytics", "Project"."singular_landing_layout" AS "Project__singular_landing_layout", "Project"."singular_landing_view" AS "Project__singular_landing_view", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."id" AS "User__id", "User"."group_id" AS "User__group_id", "User"."born_year" AS "User__born_year", "User"."active" AS "User__active", "User"."token" AS "User__token", "User"."avatar" AS "User__avatar", "User"."date_activation" AS "User__date_activation", "User"."type_avatar" AS "User__type_avatar", "User"."email" AS "User__email", "User"."name" AS "User__name", "User"."lat" AS "User__lat", "User"."lon" AS "User__lon", "User"."description" AS "User__description", "User"."app_type" AS "User__app_type", "User"."account_type" AS "User__account_type", "User"."id_old" AS "User__id_old", "User"."old" AS "User__old", "User"."gender" AS "User__gender", "User"."locale" AS "User__locale", "User"."social_link" AS "User__social_link", "User"."social_id" AS "User__social_id", "User"."sell_photo" AS "User__sell_photo", "User"."project_id" AS "User__project_id", "User"."last_view_activity" AS "User__last_view_activity", "User"."show_welcome" AS "User__show_welcome" FROM "public"."projects_users" AS "ProjectsUser" LEFT JOIN "public"."projects" AS "Project" ON ("ProjectsUser"."project_id" = "Project"."id") LEFT JOIN "public"."users" AS "User" ON ("ProjectsUser"."user_id" = "User"."id") WHERE "ProjectsUser"."project_id" = 6 AND "ProjectsUser"."user_id" IS NULL LIMIT 1 |
0 |
0 |
4 |
maybe slow
|
| BEGIN |
0 |
0 |
4 |
maybe slow |
| SELECT COUNT(*) AS "count" FROM "public"."photos" AS "Photo" WHERE "Photo"."id" = 254 |
1 |
1 |
3 |
maybe slow
|
| SELECT COUNT(*) AS "count" FROM "public"."photos" AS "Photo" WHERE "Photo"."id" = 254 |
1 |
1 |
2 |
maybe slow
|
| UPDATE "public"."photos" SET "visits" = 9382, "modified" = '2016-06-08 15:40:26' WHERE "public"."photos"."id" = '254' |
1 |
1 |
4 |
maybe slow |
| COMMIT |
1 |
1 |
4 |
maybe slow |
2 duplicate queries run.
REDES SOCIALES