Queries

SELECT DISTINCT "recipe_recipe"."id", "recipe_recipe"."user_id", "recipe_recipe"."is_translated", "recipe_recipe"."title", "recipe_recipe"."title_en", "recipe_recipe"."title_nl", "recipe_recipe"."cooking_time", "recipe_recipe"."cuisines", "recipe_recipe"."types", "recipe_recipe"."cooking_methods", "recipe_recipe"."cooking_skills", "recipe_recipe"."diet_restrictions", "recipe_recipe"."servings", "recipe_recipe"."description", "recipe_recipe"."description_en", "recipe_recipe"."description_nl", "recipe_recipe"."language", "recipe_recipe"."caption", "recipe_recipe"."publish_status", "recipe_recipe"."status", "recipe_recipe"."status_provider_id", "recipe_recipe"."sale_status", "recipe_recipe"."avg_rating", "recipe_recipe"."likes_number", "recipe_recipe"."comments_number", "recipe_recipe"."views_number", "recipe_recipe"."shares_number", "recipe_recipe"."likes_number_updated_at", "recipe_recipe"."proteins", "recipe_recipe"."fats", "recipe_recipe"."carbohydrates", "recipe_recipe"."calories", "recipe_recipe"."rejection_reason", "recipe_recipe"."price", "recipe_recipe"."supplier_price", "recipe_recipe"."homechef_share", "recipe_recipe"."platform_share", "recipe_recipe"."source_id", "recipe_recipe"."source_url", "recipe_recipe"."is_parsed", "recipe_recipe"."created_at", "recipe_recipe"."updated_at", "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "recipe_recipe" INNER JOIN "users_user" ON ("recipe_recipe"."user_id" = "users_user"."id") WHERE ("recipe_recipe"."id" IN (SELECT U0."recipe_id" FROM "site_settings_topratedrecipe" U0) AND "recipe_recipe"."publish_status" = $1 AND "recipe_recipe"."status" = $2) ORDER BY "recipe_recipe"."likes_number" DESC NULLS LAST LIMIT $3

SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/

SELECT n.nspname AS table_schema, c.relname AS table, attname AS column, format_type(a.atttypid, a.atttypmod) AS column_type, pg_get_expr(d.adbin, d.adrelid) AS default_value FROM pg_catalog.pg_attribute a INNER JOIN pg_catalog.pg_class c ON c.oid = a.attrelid INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_attrdef d ON (a.attrelid, a.attnum) = (d.adrelid, d.adnum) WHERE NOT a.attisdropped AND a.attnum > $1 AND pg_get_expr(d.adbin, d.adrelid) LIKE $2 AND n.nspname NOT LIKE $3 /*pghero*/

SET TIME ZONE 'UTC'

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40)
  OR t.typtype IN ($41, $42, $43)
  OR t.typinput = $44::regprocedure
  OR t.typelem != $45

SELECT SUM("stats_viewscounter"."count") AS "views_counter" FROM "stats_statrecord" LEFT OUTER JOIN "stats_viewscounter" ON ("stats_statrecord"."views_counter_id" = "stats_viewscounter"."id") WHERE ("stats_statrecord"."content_type_id" = $1 AND "stats_statrecord"."object_id" = $2)

WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, (total_time / $2 / $3) AS total_minutes, (total_time / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/

SELECT "recipe_recipeimage"."id", "recipe_recipeimage"."recipe_id", "recipe_recipeimage"."file", "recipe_recipeimage"."user_id", "recipe_recipeimage"."main_image", "recipe_recipeimage"."order_index", "recipe_recipeimage"."created_at" FROM "recipe_recipeimage" WHERE "recipe_recipeimage"."recipe_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)

Covered by index on (recipe_id)
Rows: 2845
Row progression: 2845, 1

Row estimates
- recipe_id (=): 1

Existing indexes
- id PRIMARY
- recipe_id
- user_id

SELECT n.nspname AS schema, c.relname AS relation, CASE WHEN c.relkind = $1 THEN $2 ELSE $3 END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ($4, $5) AND n.nspname !~ $6 AND c.relkind IN ($7, $8) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/

SELECT last_value FROM "public"."silk_profile_id_seq" UNION ALL SELECT last_value FROM "public"."silk_sqlquery_id_seq" UNION ALL SELECT last_value FROM "public"."silk_profile_queries_id_seq" UNION ALL SELECT last_value FROM "public"."chef_pencils_attachment_id_seq" UNION ALL SELECT last_value FROM "public"."chef_pencils_chefpencilrecord_id_seq" UNION ALL SELECT last_value FROM "public"."chef_pencils_chefpencilrecordcategorylink_id_seq" UNION ALL SELECT last_value FROM "public"."chef_pencils_savedchefpencilrecord_id_seq" UNION ALL SELECT last_value FROM "public"."django_admin_log_id_seq" UNION ALL SELECT last_value FROM "public"."django_content_type_id_seq" UNION ALL SELECT last_value FROM "public"."auth_group_id_seq" UNION ALL SELECT last_value FROM "public"."auth_group_permissions_id_seq" UNION ALL SELECT last_value FROM "public"."auth_permission_id_seq" UNION ALL SELECT last_value FROM "public"."cart_address_id_seq" UNION ALL SELECT last_value FROM "public"."cart_cart_id_seq" UNION ALL SELECT last_value FROM "public"."cart_cartproduct_id_seq" UNION ALL SELECT last_value FROM "public"."chef_pencils_chefpencilcategory_id_seq" UNION ALL SELECT last_value FROM "public"."django_migrations_id_seq" UNION ALL SELECT last_value FROM "public"."notifications_notify_id_seq" UNION ALL SELECT last_value FROM "public"."order_deliveryregion_id_seq" UNION ALL SELECT last_value FROM "public"."order_order_id_seq" UNION ALL SELECT last_value FROM "public"."order_orderproducts_id_seq" UNION ALL SELECT last_value FROM "public"."payments_paymentrequest_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_basicingredient_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_ingredient_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_ingredientgroup_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_ingredientgroup_units_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_recipe_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_recipeimage_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_recipereview_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_recipestep_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_recipevideo_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_savedrecipe_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_tag_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_tagreciperelation_id_seq" UNION ALL SELECT last_value FROM "public"."recipe_unit_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_banner_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_block_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_featuredrecipe_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_homepagepinnedrecipe_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_mealoftheweekrecipe_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_parserdata_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_recipeparameterscheckpoint_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_support_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_topratedrecipe_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_weekmenu_id_seq" UNION ALL SELECT last_value FROM "public"."site_settings_zipcode_id_seq" UNION ALL SELECT last_value FROM "public"."social_auth_association_id_seq" UNION ALL SELECT last_value FROM "public"."social_auth_code_id_seq" UNION ALL SELECT last_value FROM "public"."social_auth_nonce_id_seq" UNION ALL SELECT last_value FROM "public"."social_auth_partial_id_seq" UNION ALL SELECT last_value FROM "public"."social_auth_usersocialauth_id_seq" UNION ALL SELECT last_value FROM "public"."social_comment_id_seq" UNION ALL SELECT last_value FROM "public"."social_commentlike_id_seq" UNION ALL SELECT last_value FROM "public"."social_like_id_seq" UNION ALL SELECT last_value FROM "public"."social_rating_id_seq" UNION ALL SELECT last_value FROM "public"."stats_sharescounter_id_seq" UNION ALL SELECT last_value FROM "public"."stats_statrecord_id_seq" UNION ALL SELECT last_value FROM "public"."stats_viewscounter_id_seq" UNION ALL SELECT last_value FROM "public"."users_blacklistedtoken_id_seq" UNION ALL SELECT last_value FROM "public"."users_favoriterecipe_id_seq" UNION ALL SELECT last_value FROM "public"."users_outstandingtoken_id_seq" UNION ALL SELECT last_value FROM "public"."users_rolemodel_id_seq" UNION ALL SELECT last_value FROM "public"."users_supplierdocument_id_seq" UNION ALL SELECT last_value FROM "public"."users_supplierprofile_id_seq" UNION ALL SELECT last_value FROM "public"."users_user_id_seq" UNION ALL SELECT last_value FROM "public"."users_user_groups_id_seq" UNION ALL SELECT last_value FROM "public"."users_user_user_permissions_id_seq" UNION ALL SELECT last_value FROM "public"."users_userviewhistoryrecord_id_seq" UNION ALL SELECT last_value FROM "public"."users_workexperiencerecord_id_seq" /*pghero*/

SELECT "recipe_recipe"."id", "recipe_recipe"."user_id", "recipe_recipe"."is_translated", "recipe_recipe"."title", "recipe_recipe"."title_en", "recipe_recipe"."title_nl", "recipe_recipe"."cooking_time", "recipe_recipe"."cuisines", "recipe_recipe"."types", "recipe_recipe"."cooking_methods", "recipe_recipe"."cooking_skills", "recipe_recipe"."diet_restrictions", "recipe_recipe"."servings", "recipe_recipe"."description", "recipe_recipe"."description_en", "recipe_recipe"."description_nl", "recipe_recipe"."language", "recipe_recipe"."caption", "recipe_recipe"."publish_status", "recipe_recipe"."status", "recipe_recipe"."status_provider_id", "recipe_recipe"."sale_status", "recipe_recipe"."avg_rating", "recipe_recipe"."likes_number", "recipe_recipe"."comments_number", "recipe_recipe"."views_number", "recipe_recipe"."shares_number", "recipe_recipe"."likes_number_updated_at", "recipe_recipe"."proteins", "recipe_recipe"."fats", "recipe_recipe"."carbohydrates", "recipe_recipe"."calories", "recipe_recipe"."rejection_reason", "recipe_recipe"."price", "recipe_recipe"."supplier_price", "recipe_recipe"."homechef_share", "recipe_recipe"."platform_share", "recipe_recipe"."source_id", "recipe_recipe"."source_url", "recipe_recipe"."is_parsed", "recipe_recipe"."created_at", "recipe_recipe"."updated_at", CASE WHEN "recipe_recipe"."sale_status" = $1 THEN $2 ELSE $3 END AS "is_for_sale", CASE WHEN "recipe_recipe"."user_id" = $4 THEN $5 ELSE $6 END AS "is_api_user", "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "recipe_recipe" INNER JOIN "users_user" ON ("recipe_recipe"."user_id" = "users_user"."id") WHERE ("recipe_recipe"."publish_status" = $7 AND "recipe_recipe"."status" = $8 AND "recipe_recipe"."publish_status" = $9 AND "recipe_recipe"."status" = $10 AND "recipe_recipe"."publish_status" = $11 AND "recipe_recipe"."status" = $12) ORDER BY "recipe_recipe"."likes_number" DESC LIMIT $13

SELECT n.nspname AS schema, c.relname AS table, $1 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid)) AS transactions_left FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_class t ON c.reltoastrelid = t.oid WHERE c.relkind = $2 AND ($3 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid))) < $4 ORDER BY 3, 1, 2 /*pghero*/

SELECT COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$1]::integer[] THEN $2 ELSE $3 END) AS "vegan_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$4]::integer[] THEN $5 ELSE $6 END) AS "vegetarian_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$7]::integer[] THEN $8 ELSE $9 END) AS "pescetarian_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$10]::integer[] THEN $11 ELSE $12 END) AS "gluten_free_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$13]::integer[] THEN $14 ELSE $15 END) AS "grain_free_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$16]::integer[] THEN $17 ELSE $18 END) AS "dairy_free_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$19]::integer[] THEN $20 ELSE $21 END) AS "high_protein_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$22]::integer[] THEN $23 ELSE $24 END) AS "low_sodium_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$25]::integer[] THEN $26 ELSE $27 END) AS "low_carb_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$28]::integer[] THEN $29 ELSE $30 END) AS "paleo_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$31]::integer[] THEN $32 ELSE $33 END) AS "primal_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$34]::integer[] THEN $35 ELSE $36 END) AS "ketogenic_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$37]::integer[] THEN $38 ELSE $39 END) AS "fodmap_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$40]::integer[] THEN $41 ELSE $42 END) AS "whole_30_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$43]::integer[] THEN $44 ELSE $45 END) AS "low_fodmap_num", COUNT(CASE WHEN "recipe_recipe"."diet_restrictions" @> ARRAY[$46]::integer[] THEN $47 ELSE $48 END) AS "high_fodmap_num" FROM "recipe_recipe" WHERE ("recipe_recipe"."publish_status" = $49 AND "recipe_recipe"."status" = $50 AND "recipe_recipe"."publish_status" = $51 AND "recipe_recipe"."status" = $52)

SELECT "recipe_recipestep"."id", "recipe_recipestep"."num", "recipe_recipestep"."title", "recipe_recipestep"."title_en", "recipe_recipestep"."title_nl", "recipe_recipestep"."description", "recipe_recipestep"."description_en", "recipe_recipestep"."description_nl", "recipe_recipestep"."is_translated", "recipe_recipestep"."recipe_id", "recipe_recipestep"."created_at" FROM "recipe_recipestep" WHERE "recipe_recipestep"."recipe_id" = $1

SELECT t.oid, t.typname
FROM pg_type as t
WHERE t.typname IN ($1, $2, $3, $4, $5, $6, $7)

SELECT "recipe_recipevideo"."id", "recipe_recipevideo"."user_id", "recipe_recipevideo"."recipe_id", "recipe_recipevideo"."video", "recipe_recipevideo"."video_thumbnail", "recipe_recipevideo"."created_at" FROM "recipe_recipevideo" WHERE "recipe_recipevideo"."recipe_id" = $1 LIMIT $2

SELECT COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$1]::integer[] THEN $2 ELSE $3 END) AS "broiling_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$4]::integer[] THEN $5 ELSE $6 END) AS "grilling_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$7]::integer[] THEN $8 ELSE $9 END) AS "roasting_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$10]::integer[] THEN $11 ELSE $12 END) AS "baking_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$13]::integer[] THEN $14 ELSE $15 END) AS "sauteing_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$16]::integer[] THEN $17 ELSE $18 END) AS "simmering_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$19]::integer[] THEN $20 ELSE $21 END) AS "boiling_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$22]::integer[] THEN $23 ELSE $24 END) AS "steaming_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$25]::integer[] THEN $26 ELSE $27 END) AS "braising_num", COUNT(CASE WHEN "recipe_recipe"."cooking_methods" @> ARRAY[$28]::integer[] THEN $29 ELSE $30 END) AS "stewing_num" FROM "recipe_recipe" WHERE ("recipe_recipe"."publish_status" = $31 AND "recipe_recipe"."status" = $32 AND "recipe_recipe"."publish_status" = $33 AND "recipe_recipe"."status" = $34)

SELECT schemaname AS schema, relname AS table, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, n_dead_tup AS dead_rows, n_live_tup AS live_rows FROM pg_stat_user_tables ORDER BY 1, 2 /*pghero*/

SET SESSION timezone TO 'UTC'

SELECT COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$1]::integer[] THEN $2 ELSE $3 END) AS "breakfast_num", COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$4]::integer[] THEN $5 ELSE $6 END) AS "lunch_num", COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$7]::integer[] THEN $8 ELSE $9 END) AS "dinner_num", COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$10]::integer[] THEN $11 ELSE $12 END) AS "dessert_num", COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$13]::integer[] THEN $14 ELSE $15 END) AS "appetizer_num", COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$16]::integer[] THEN $17 ELSE $18 END) AS "salad_num", COUNT(CASE WHEN "recipe_recipe"."types" @> ARRAY[$19]::integer[] THEN $20 ELSE $21 END) AS "bread_num" FROM "recipe_recipe" WHERE ("recipe_recipe"."publish_status" = $22 AND "recipe_recipe"."status" = $23 AND "recipe_recipe"."publish_status" = $24 AND "recipe_recipe"."status" = $25)

SELECT n.nspname AS schema, c.relname AS sequence, has_sequence_privilege(c.oid, $1) AS readable FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = $2 AND n.nspname NOT IN ($3, $4) /*pghero*/

SELECT schemaname AS schema, relname AS table, indexrelname AS index, pg_relation_size(i.indexrelid) AS size_bytes, idx_scan as index_scans FROM pg_stat_user_indexes ui INNER JOIN pg_index i ON ui.indexrelid = i.indexrelid WHERE NOT indisunique AND idx_scan <= $1 ORDER BY pg_relation_size(i.indexrelid) DESC, relname ASC /*pghero*/

SELECT "recipe_recipe"."id", "recipe_recipe"."user_id", "recipe_recipe"."is_translated", "recipe_recipe"."title", "recipe_recipe"."title_en", "recipe_recipe"."title_nl", "recipe_recipe"."cooking_time", "recipe_recipe"."cuisines", "recipe_recipe"."types", "recipe_recipe"."cooking_methods", "recipe_recipe"."cooking_skills", "recipe_recipe"."diet_restrictions", "recipe_recipe"."servings", "recipe_recipe"."description", "recipe_recipe"."description_en", "recipe_recipe"."description_nl", "recipe_recipe"."language", "recipe_recipe"."caption", "recipe_recipe"."publish_status", "recipe_recipe"."status", "recipe_recipe"."status_provider_id", "recipe_recipe"."sale_status", "recipe_recipe"."avg_rating", "recipe_recipe"."likes_number", "recipe_recipe"."comments_number", "recipe_recipe"."views_number", "recipe_recipe"."shares_number", "recipe_recipe"."likes_number_updated_at", "recipe_recipe"."proteins", "recipe_recipe"."fats", "recipe_recipe"."carbohydrates", "recipe_recipe"."calories", "recipe_recipe"."rejection_reason", "recipe_recipe"."price", "recipe_recipe"."supplier_price", "recipe_recipe"."homechef_share", "recipe_recipe"."platform_share", "recipe_recipe"."source_id", "recipe_recipe"."source_url", "recipe_recipe"."is_parsed", "recipe_recipe"."created_at", "recipe_recipe"."updated_at", "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "recipe_recipe" INNER JOIN "users_user" ON ("recipe_recipe"."user_id" = "users_user"."id") WHERE "recipe_recipe"."id" = $1 LIMIT $2

SELECT COUNT(CASE WHEN "recipe_recipe"."cooking_skills" = $1 THEN $2 ELSE $3 END) AS "easy_num", COUNT(CASE WHEN "recipe_recipe"."cooking_skills" = $4 THEN $5 ELSE $6 END) AS "medium_num", COUNT(CASE WHEN "recipe_recipe"."cooking_skills" = $7 THEN $8 ELSE $9 END) AS "hard_num" FROM "recipe_recipe" WHERE ("recipe_recipe"."publish_status" = $10 AND "recipe_recipe"."status" = $11 AND "recipe_recipe"."publish_status" = $12 AND "recipe_recipe"."status" = $13)

SELECT "recipe_basicingredient"."id", "recipe_basicingredient"."title", "recipe_basicingredient"."title_en", "recipe_basicingredient"."title_nl", "recipe_basicingredient"."is_translated", "recipe_basicingredient"."group_id", "recipe_basicingredient"."is_approved", "recipe_basicingredient"."created_at", "recipe_basicingredient"."updated_at" FROM "recipe_basicingredient" WHERE "recipe_basicingredient"."id" = $1 LIMIT $2

Covered by index on (id)
Rows: 931
Row progression: 931, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- group_id
- title UNIQUE
- title varchar_pattern_ops
- title_en UNIQUE
- title_en varchar_pattern_ops
- title_nl UNIQUE
- title_nl varchar_pattern_ops

INSERT INTO "stats_viewscounter" ("count") VALUES ($1) RETURNING "stats_viewscounter"."id"

SELECT "recipe_ingredient"."id", "recipe_ingredient"."title", "recipe_ingredient"."title_en", "recipe_ingredient"."title_nl", "recipe_ingredient"."is_translated", "recipe_ingredient"."basic_ingredient_id", "recipe_ingredient"."quantity", "recipe_ingredient"."custom_unit_id", "recipe_ingredient"."unit", "recipe_ingredient"."recipe_id", "recipe_ingredient"."created_at" FROM "recipe_ingredient" WHERE "recipe_ingredient"."recipe_id" = $1

Covered by index on (recipe_id)
Rows: 26696
Row progression: 26696, 10

Row estimates
- recipe_id (=): 10

Existing indexes
- id PRIMARY
- basic_ingredient_id
- custom_unit_id
- recipe_id

SELECT pid, state, application_name AS source, age(NOW(), COALESCE(query_start, xact_start)) AS duration, (wait_event IS NOT NULL) AS waiting, query, COALESCE(query_start, xact_start) AS started_at, EXTRACT($1 FROM NOW() - COALESCE(query_start, xact_start)) * $2 AS duration_ms, usename AS user, backend_type FROM pg_stat_activity WHERE state <> $3 AND pid <> pg_backend_pid() AND datname = current_database() AND NOW() - COALESCE(query_start, xact_start) > interval $4 AND query <> $5 ORDER BY COALESCE(query_start, xact_start) DESC /*pghero*/

SELECT COUNT(*) AS "__count" FROM "recipe_recipe" WHERE ("recipe_recipe"."sale_status" = $1 AND "recipe_recipe"."status" = $2)

CREATE INDEX CONCURRENTLY ON recipe_recipe (sale_status)

Rows: 2551
Row progression: 2551, 638, 213

Row estimates
- sale_status (=): 638
- status (=): 850

Existing indexes
- id PRIMARY
- source_id UNIQUE
- source_url UNIQUE
- source_url varchar_pattern_ops
- status_provider_id
- user_id
- user_id, publish_status, status

SELECT pg_database_size(current_database()) /*pghero*/

INSERT INTO "stats_statrecord" ("content_type_id", "object_id", "views_counter_id", "shares_counter_id", "date") VALUES ($1, $2, $3, $4, $5::date) RETURNING "stats_statrecord"."id"

SELECT COUNT(*) FROM (SELECT CASE WHEN "recipe_recipe"."sale_status" = $1 THEN $2 ELSE $3 END AS "is_for_sale", CASE WHEN "recipe_recipe"."user_id" = $4 THEN $5 ELSE $6 END AS "is_api_user" FROM "recipe_recipe" WHERE ("recipe_recipe"."publish_status" = $7 AND "recipe_recipe"."status" = $8 AND "recipe_recipe"."publish_status" = $9 AND "recipe_recipe"."status" = $10 AND "recipe_recipe"."publish_status" = $11 AND "recipe_recipe"."status" = $12)) subquery

SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*pghero*/

INSERT INTO "stats_sharescounter" ("count") VALUES ($1) RETURNING "stats_sharescounter"."id"

SELECT nsp.nspname AS schema, rel.relname AS table, con.conname AS name, fnsp.nspname AS referenced_schema, frel.relname AS referenced_table FROM pg_catalog.pg_constraint con INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid LEFT JOIN pg_catalog.pg_class frel ON frel.oid = con.confrelid LEFT JOIN pg_catalog.pg_namespace nsp ON nsp.oid = con.connamespace LEFT JOIN pg_catalog.pg_namespace fnsp ON fnsp.oid = frel.relnamespace WHERE con.convalidated = $1 /*pghero*/

SELECT nspname AS schema, relname AS table, reltuples::bigint AS estimated_rows, pg_total_relation_size(pg_class.oid) AS size_bytes FROM pg_class INNER JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE relkind = $1 AND nspname = $2 AND relname IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26) ORDER BY 1, 2 /*pghero*/

UPDATE "stats_viewscounter" SET "count" = ("stats_viewscounter"."count" + $1) WHERE "stats_viewscounter"."id" IN (SELECT U0."id" FROM "stats_viewscounter" U0 INNER JOIN "stats_statrecord" U1 ON (U0."id" = U1."views_counter_id") WHERE (U1."date" = $2::date AND U1."id" = $3))

SELECT nspname AS schema, relname AS table, reltuples::bigint AS estimated_rows, pg_total_relation_size(pg_class.oid) AS size_bytes FROM pg_class INNER JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE relkind = $1 AND nspname = $2 AND relname IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30) ORDER BY 1, 2 /*pghero*/

SELECT COUNT(*) AS "__count" FROM "recipe_recipe" WHERE "recipe_recipe"."status" = $1

SELECT "recipe_recipeimage"."id", "recipe_recipeimage"."recipe_id", "recipe_recipeimage"."file", "recipe_recipeimage"."user_id", "recipe_recipeimage"."main_image", "recipe_recipeimage"."order_index", "recipe_recipeimage"."created_at" FROM "recipe_recipeimage" WHERE "recipe_recipeimage"."recipe_id" = $1

Covered by index on (recipe_id)
Rows: 2845
Row progression: 2845, 1

Row estimates
- recipe_id (=): 1

Existing indexes
- id PRIMARY
- recipe_id
- user_id

SELECT "recipe_recipe"."id", "recipe_recipe"."user_id", "recipe_recipe"."is_translated", "recipe_recipe"."title", "recipe_recipe"."title_en", "recipe_recipe"."title_nl", "recipe_recipe"."cooking_time", "recipe_recipe"."cuisines", "recipe_recipe"."types", "recipe_recipe"."cooking_methods", "recipe_recipe"."cooking_skills", "recipe_recipe"."diet_restrictions", "recipe_recipe"."servings", "recipe_recipe"."description", "recipe_recipe"."description_en", "recipe_recipe"."description_nl", "recipe_recipe"."language", "recipe_recipe"."caption", "recipe_recipe"."publish_status", "recipe_recipe"."status", "recipe_recipe"."status_provider_id", "recipe_recipe"."sale_status", "recipe_recipe"."avg_rating", "recipe_recipe"."likes_number", "recipe_recipe"."comments_number", "recipe_recipe"."views_number", "recipe_recipe"."shares_number", "recipe_recipe"."likes_number_updated_at", "recipe_recipe"."proteins", "recipe_recipe"."fats", "recipe_recipe"."carbohydrates", "recipe_recipe"."calories", "recipe_recipe"."rejection_reason", "recipe_recipe"."price", "recipe_recipe"."supplier_price", "recipe_recipe"."homechef_share", "recipe_recipe"."platform_share", "recipe_recipe"."source_id", "recipe_recipe"."source_url", "recipe_recipe"."is_parsed", "recipe_recipe"."created_at", "recipe_recipe"."updated_at" FROM "recipe_recipe" WHERE "recipe_recipe"."id" = $1 LIMIT $2

Covered by index on (id)
Rows: 2551
Row progression: 2551, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- source_id UNIQUE
- source_url UNIQUE
- source_url varchar_pattern_ops
- status_provider_id
- user_id
- user_id, publish_status, status

SELECT "recipe_recipeimage"."id", "recipe_recipeimage"."recipe_id", "recipe_recipeimage"."file", "recipe_recipeimage"."user_id", "recipe_recipeimage"."main_image", "recipe_recipeimage"."order_index", "recipe_recipeimage"."created_at" FROM "recipe_recipeimage" WHERE "recipe_recipeimage"."recipe_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12)

Covered by index on (recipe_id)
Rows: 2845
Row progression: 2845, 1

Row estimates
- recipe_id (=): 1

Existing indexes
- id PRIMARY
- recipe_id
- user_id

SET standard_conforming_strings = on

SELECT * FROM pg_stat_statements LIMIT $1 /*pghero*/

set client_encoding to 'UTF8'

SELECT c.relname FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = ANY (current_schemas($1)) AND c.relname = $2 AND c.relkind IN ($3,$4)

SELECT schemaname AS schema, tablename AS table, attname AS column, null_frac, n_distinct FROM pg_stats WHERE schemaname = $1 AND tablename IN ($2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29) ORDER BY 1, 2, 3 /*pghero*/

SELECT "chef_pencils_chefpencilcategory"."id", "chef_pencils_chefpencilcategory"."title", "chef_pencils_chefpencilcategory"."created_at", "chef_pencils_chefpencilcategory"."updated_at" FROM "chef_pencils_chefpencilcategory" INNER JOIN "chef_pencils_chefpencilrecordcategorylink" ON ("chef_pencils_chefpencilcategory"."id" = "chef_pencils_chefpencilrecordcategorylink"."category_id") WHERE "chef_pencils_chefpencilrecordcategorylink"."chefpencil_record_id" = $1

SELECT $2 FROM ONLY "public"."django_content_type" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

SELECT "recipe_unit"."id", "recipe_unit"."is_translated", "recipe_unit"."metric_name", "recipe_unit"."metric_name_en", "recipe_unit"."metric_name_nl", "recipe_unit"."metric_value", "recipe_unit"."metric_unit", "recipe_unit"."imperial_name", "recipe_unit"."imperial_name_en", "recipe_unit"."imperial_name_nl", "recipe_unit"."imperial_value", "recipe_unit"."imperial_unit", "recipe_unit"."primary_type", "recipe_unit"."created_at", "recipe_unit"."updated_at" FROM "recipe_unit" WHERE "recipe_unit"."id" = $1 LIMIT $2

SELECT "stats_statrecord"."id", "stats_statrecord"."content_type_id", "stats_statrecord"."object_id", "stats_statrecord"."views_counter_id", "stats_statrecord"."shares_counter_id", "stats_statrecord"."date" FROM "stats_statrecord" INNER JOIN "django_content_type" ON ("stats_statrecord"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."model" = $1 AND "stats_statrecord"."date" = $2::date AND "stats_statrecord"."object_id" = $3) LIMIT $4

SET client_min_messages TO 'warning'

SELECT slot_name, database, active FROM pg_replication_slots /*pghero*/

SELECT $1

SELECT schemaname AS schema, tablename AS table, attname AS column, null_frac, n_distinct FROM pg_stats WHERE schemaname = $1 AND tablename IN ($2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ORDER BY 1, 2, 3 /*pghero*/

SELECT "social_like"."id", "social_like"."user_id", "social_like"."ip", "social_like"."content_type_id", "social_like"."object_id", "social_like"."created_at" FROM "social_like" INNER JOIN "django_content_type" ON ("social_like"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."model" = $1 AND "social_like"."ip" = $2::inet AND "social_like"."object_id" = $3) LIMIT $4

SELECT t.oid, typarray FROM pg_type t JOIN pg_namespace ns ON typnamespace = ns.oid WHERE typname = $1

SHOW TIME ZONE

SELECT "django_content_type"."id", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = $1 AND "django_content_type"."model" = $2) LIMIT $3

SELECT "chef_pencils_chefpencilrecord"."id", "chef_pencils_chefpencilrecord"."title", "chef_pencils_chefpencilrecord"."user_id", "chef_pencils_chefpencilrecord"."html_content", "chef_pencils_chefpencilrecord"."status", "chef_pencils_chefpencilrecord"."rejection_reason", "chef_pencils_chefpencilrecord"."avg_rating", "chef_pencils_chefpencilrecord"."likes_number", "chef_pencils_chefpencilrecord"."views_number", "chef_pencils_chefpencilrecord"."created_at", "chef_pencils_chefpencilrecord"."updated_at" FROM "chef_pencils_chefpencilrecord" WHERE "chef_pencils_chefpencilrecord"."id" = $1 LIMIT $2

SELECT COUNT(*) AS "__count" FROM "users_user" WHERE "users_user"."user_type" = $1

SELECT COUNT(*) AS "__count" FROM "site_settings_featuredrecipe"

SELECT "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "users_user" WHERE ("users_user"."full_name" = $1 AND "users_user"."is_staff") LIMIT $2

SELECT "users_rolemodel"."id", "users_rolemodel"."user_id", "users_rolemodel"."name", "users_rolemodel"."file", "users_rolemodel"."created_at" FROM "users_rolemodel" WHERE "users_rolemodel"."user_id" = $1

SELECT "chef_pencils_chefpencilrecord"."id", "chef_pencils_chefpencilrecord"."title", "chef_pencils_chefpencilrecord"."user_id", "chef_pencils_chefpencilrecord"."html_content", "chef_pencils_chefpencilrecord"."status", "chef_pencils_chefpencilrecord"."rejection_reason", "chef_pencils_chefpencilrecord"."avg_rating", "chef_pencils_chefpencilrecord"."likes_number", "chef_pencils_chefpencilrecord"."views_number", "chef_pencils_chefpencilrecord"."created_at", "chef_pencils_chefpencilrecord"."updated_at", "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "chef_pencils_chefpencilrecord" INNER JOIN "users_user" ON ("chef_pencils_chefpencilrecord"."user_id" = "users_user"."id") WHERE "chef_pencils_chefpencilrecord"."id" IN ($1, $2)

SELECT pg_stat_activity.pid, datname AS database, usename AS user, application_name AS source, client_addr AS ip, state, ssl FROM pg_stat_activity LEFT JOIN pg_stat_ssl ON pg_stat_activity.pid = pg_stat_ssl.pid ORDER BY pg_stat_activity.pid /*pghero*/

SELECT "chef_pencils_chefpencilimage"."id", "chef_pencils_chefpencilimage"."image", "chef_pencils_chefpencilimage"."chefpencil_record_id", "chef_pencils_chefpencilimage"."main_image", "chef_pencils_chefpencilimage"."order_index", "chef_pencils_chefpencilimage"."created_at", "chef_pencils_chefpencilimage"."updated_at" FROM "chef_pencils_chefpencilimage" WHERE "chef_pencils_chefpencilimage"."chefpencil_record_id" = $1

SELECT "site_settings_mealoftheweekrecipe"."id", "site_settings_mealoftheweekrecipe"."recipe_id", "site_settings_mealoftheweekrecipe"."created_at", "site_settings_mealoftheweekrecipe"."updated_at" FROM "site_settings_mealoftheweekrecipe" ORDER BY "site_settings_mealoftheweekrecipe"."id" ASC LIMIT $1

SELECT $2 FROM ONLY "public"."stats_viewscounter" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

SELECT pid, state, application_name AS source, age(NOW(), COALESCE(query_start, xact_start)) AS duration, (wait_event IS NOT NULL) AS waiting, query, COALESCE(query_start, xact_start) AS started_at, EXTRACT($1 FROM NOW() - COALESCE(query_start, xact_start)) * $2 AS duration_ms, usename AS user, backend_type FROM pg_stat_activity WHERE state <> $3 AND pid <> pg_backend_pid() AND datname = current_database() ORDER BY COALESCE(query_start, xact_start) DESC /*pghero*/

SELECT "recipe_basicingredient"."id", "recipe_basicingredient"."title", "recipe_basicingredient"."title_en", "recipe_basicingredient"."title_nl", "recipe_basicingredient"."is_translated", "recipe_basicingredient"."group_id", "recipe_basicingredient"."is_approved", "recipe_basicingredient"."created_at", "recipe_basicingredient"."updated_at" FROM "recipe_basicingredient" WHERE "recipe_basicingredient"."id" IS NULL LIMIT $1

Covered by index on (id)
Rows: 931
Row progression: 931, 0

Row estimates
- id (null): 0

Existing indexes
- id PRIMARY
- group_id
- title UNIQUE
- title varchar_pattern_ops
- title_en UNIQUE
- title_en varchar_pattern_ops
- title_nl UNIQUE
- title_nl varchar_pattern_ops

SELECT "chef_pencils_chefpencilrecord"."id" FROM "chef_pencils_chefpencilrecord" ORDER BY "chef_pencils_chefpencilrecord"."created_at" DESC LIMIT $1

SELECT "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "users_user" WHERE "users_user"."id" = $1 LIMIT $2

SELECT state FROM pg_stat_replication /*pghero*/

SELECT $2 FROM ONLY "public"."stats_sharescounter" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

SELECT "cart_address"."id", "cart_address"."user_id", "cart_address"."city", "cart_address"."street", "cart_address"."house", "cart_address"."flat", "cart_address"."zipcode" FROM "cart_address" WHERE "cart_address"."user_id" = $1

SELECT "users_favoriterecipe"."id", "users_favoriterecipe"."recipe_id", "users_favoriterecipe"."user_id", "users_favoriterecipe"."created_at" FROM "users_favoriterecipe" WHERE "users_favoriterecipe"."user_id" = $1

SELECT pid, phase FROM pg_stat_progress_vacuum WHERE datname = current_database() /*pghero*/

SELECT "chef_pencils_chefpencilimage"."id", "chef_pencils_chefpencilimage"."image", "chef_pencils_chefpencilimage"."chefpencil_record_id", "chef_pencils_chefpencilimage"."main_image", "chef_pencils_chefpencilimage"."order_index", "chef_pencils_chefpencilimage"."created_at", "chef_pencils_chefpencilimage"."updated_at" FROM "chef_pencils_chefpencilimage" WHERE "chef_pencils_chefpencilimage"."chefpencil_record_id" IN ($1, $2)

SELECT "users_workexperiencerecord"."id", "users_workexperiencerecord"."user_id", "users_workexperiencerecord"."text", "users_workexperiencerecord"."created_at" FROM "users_workexperiencerecord" WHERE "users_workexperiencerecord"."user_id" = $1

SELECT "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "users_user" WHERE ("users_user"."user_type" = $1 AND "users_user"."is_active" AND "users_user"."status" = $2 AND "users_user"."id" IS NULL) LIMIT $3

SELECT COUNT(*) AS "__count" FROM "order_order" WHERE "order_order"."status" = $1

SELECT "users_user"."id", "users_user"."last_login", "users_user"."is_superuser", "users_user"."is_staff", "users_user"."date_joined", "users_user"."email", "users_user"."first_name", "users_user"."last_name", "users_user"."full_name", "users_user"."phone_number", "users_user"."avatar", "users_user"."city", "users_user"."status", "users_user"."user_type", "users_user"."language", "users_user"."recommended_recipes", "users_user"."bio", "users_user"."cooking_philosophy", "users_user"."personal_cooking_mission", "users_user"."source_of_inspiration", "users_user"."password", "users_user"."is_active", "users_user"."is_email_active", "users_user"."activation_email_code", "users_user"."email_activation_date", "users_user"."reset_password_code", "users_user"."reset_password_code_expire", "users_user"."created_at", "users_user"."updated_at" FROM "users_user" WHERE "users_user"."id" IS NULL LIMIT $1

SELECT "site_settings_featuredrecipe"."id", "site_settings_featuredrecipe"."recipe_id", "site_settings_featuredrecipe"."created_at", "site_settings_featuredrecipe"."updated_at" FROM "site_settings_featuredrecipe"

SELECT pg_is_in_recovery() /*pghero*/

SELECT COUNT(*) AS "__count" FROM "social_comment" INNER JOIN "chef_pencils_chefpencilrecord" ON ("social_comment"."object_id" = "chef_pencils_chefpencilrecord"."id" AND ("social_comment"."content_type_id" = $1)) WHERE "chef_pencils_chefpencilrecord"."id" = $2

SELECT typarray FROM pg_type WHERE typname = $1

SHOW min_wal_size /*pghero*/

SHOW checkpoint_completion_target /*pghero*/

SHOW max_connections /*pghero*/

SHOW shared_buffers /*pghero*/

SHOW wal_buffers /*pghero*/

SHOW max_wal_size /*pghero*/

SHOW server_version_num /*pghero*/

SHOW default_statistics_target /*pghero*/

SHOW work_mem /*pghero*/

SHOW effective_cache_size /*pghero*/

SHOW maintenance_work_mem /*pghero*/

SHOW server_version /*pghero*/