Слоган для инструмента против линьки

0.026671171188354

Array ( )

connect

0.0056009292602539

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'contest_projects' ORDER BY a.attnum

0.0010650157928467

Array ( )

SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1598)))

0.0024960041046143

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'contest_statuses' ORDER BY a.attnum

0.00048398971557617

Array ( )

SELECT "contest_statuses".* FROM "contest_statuses" WHERE ((("contest_statuses"."id" = 10)))

0.0027809143066406

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'contest_work_vote_winners' AND n.nspname = 'boutique' ORDER BY a.attnum

0.0013401508331299

Array ( )

SELECT "contest_work_vote_winners".* FROM "boutique"."contest_work_vote_winners" WHERE (pid =1598) ORDER BY "count" DESC LIMIT 4

0.00072288513183594

Array ( )

SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1598)

0.0024359226226807

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'contest_works' ORDER BY a.attnum

0.00069999694824219

Array ( )

SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 449828)))

0.0025761127471924

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'contest_specs' ORDER BY a.attnum

0.00069689750671387

Array ( )

SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 17)))

0.003087043762207

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'accounts' AND n.nspname = 'boutique' ORDER BY a.attnum

0.001378059387207

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 336100)))

0.0021400451660156

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'user_url' AND n.nspname = 'boutique' ORDER BY a.attnum

0.0008389949798584

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =336100) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0020561218261719

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'shop_pro_account_bind' ORDER BY a.attnum

0.00086116790771484

Array ( )

SELECT "shop_pro_account_bind".* FROM "shop_pro_account_bind" WHERE (pro_to > CURRENT_TIMESTAMP)

0.0017209053039551

Array ( )

SELECT DISTINCT "contest_winners"."uid" FROM "contest_winners"

0.0048749446868896

Array ( )

SELECT "contest_works".* FROM "contest_works" WHERE (pid=1598) AND (id!=449828) AND (status=1) ORDER BY "pdate" DESC

0.00082111358642578

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 349694)))

0.00056290626525879

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =349694) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00070881843566895

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 370011)))

0.00051712989807129

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =370011) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00066614151000977

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 93)))

0.00053310394287109

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =93) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00067305564880371

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 343095)))

0.00048995018005371

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =343095) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00061392784118652

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 304564)))

0.00048303604125977

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =304564) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00061893463134766

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300267)))

0.0004889965057373

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300267) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00058913230895996

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 363599)))

0.0004429817199707

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =363599) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00056195259094238

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 369279)))

0.00043797492980957

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =369279) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00058698654174805

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 375710)))

0.00050997734069824

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =375710) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00060415267944336

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 319735)))

0.00046300888061523

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =319735) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00058603286743164

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300076)))

0.00042200088500977

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300076) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00054502487182617

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300320)))

0.00045609474182129

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300320) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0006101131439209

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300179)))

0.00041890144348145

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300179) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00054001808166504

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 362619)))

0.00037503242492676

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =362619) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00060606002807617

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 374349)))

0.0004727840423584

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =374349) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00059103965759277

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300260)))

0.00044512748718262

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300260) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00058603286743164

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 365965)))

0.00053191184997559

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =365965) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00062203407287598

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 315334)))

0.0005180835723877

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =315334) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00079607963562012

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 357279)))

0.0005791187286377

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =357279) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00063109397888184

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 360457)))

0.00059795379638672

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =360457) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00066995620727539

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300167)))

0.00054311752319336

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300167) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00060701370239258

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300325)))

0.00061702728271484

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300325) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00089287757873535

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 358366)))

0.00067305564880371

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =358366) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00087499618530273

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 341932)))

0.00064301490783691

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =341932) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0010380744934082

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300308)))

0.00074100494384766

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300308) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00084304809570312

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 331905)))

0.00064992904663086

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =331905) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00086283683776855

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300923)))

0.00062799453735352

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300923) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00081801414489746

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300148)))

0.00063109397888184

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300148) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00071811676025391

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300372)))

0.00059986114501953

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300372) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00081086158752441

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 302489)))

0.00062012672424316

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =302489) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00079011917114258

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300098)))

0.00060486793518066

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300098) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00074887275695801

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 374311)))

0.00063085556030273

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =374311) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00073409080505371

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300511)))

0.00055503845214844

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300511) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00072002410888672

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300255)))

0.00067591667175293

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300255) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0005340576171875

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300075)))

0.00037789344787598

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300075) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00048995018005371

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 314097)))

0.00047111511230469

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =314097) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00050783157348633

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300088)))

0.00046920776367188

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300088) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00053095817565918

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 369031)))

0.00046396255493164

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =369031) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00052309036254883

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 375007)))

0.0004730224609375

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =375007) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0005040168762207

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300340)))

0.00046586990356445

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300340) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00051403045654297

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 315873)))

0.00046014785766602

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =315873) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00052499771118164

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 305237)))

0.00046515464782715

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =305237) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0005190372467041

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 370895)))

0.00047898292541504

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =370895) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0010349750518799

Array ( )

SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime

0.0022668838500977

Array ( )

SELECT a.attnum, n.nspname, c.relname, a.attname AS colname, t.typname AS type, a.atttypmod, FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type, pg_get_expr(d.adbin, d.adrelid) AS default_value, --d.adsrc AS default_value, a.attnotnull AS notnull, a.attlen AS length, co.contype, ARRAY_TO_STRING(co.conkey, ',') AS conkey FROM pg_attribute AS a JOIN pg_class AS c ON a.attrelid = c.oid JOIN pg_namespace AS n ON c.relnamespace = n.oid JOIN pg_type AS t ON a.atttypid = t.oid LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid AND a.attnum = ANY(co.conkey) AND co.contype = 'p') LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum WHERE a.attnum > 0 AND c.relname = 'specs' AND n.nspname = 'boutique' ORDER BY a.attnum

0.00095582008361816

Array ( )

SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC