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.0015990734100342
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 592)))
0.0027210712432861
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.00085592269897461
Array
(
)
SELECT "contest_statuses".* FROM "contest_statuses" WHERE ((("contest_statuses"."id" = 10)))
0.0027399063110352
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.001309871673584
Array
(
)
SELECT "contest_work_vote_winners".* FROM "boutique"."contest_work_vote_winners" WHERE (pid =592) ORDER BY "count" DESC LIMIT 4
0.00098299980163574
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=592)
0.0031719207763672
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.0012459754943848
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 93740)))
0.0042228698730469
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.001460075378418
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 16)))
0.0059051513671875
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.0029058456420898
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 331905)))
0.0030250549316406
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.0014469623565674
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =331905) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0032820701599121
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.0010268688201904
Array
(
)
SELECT "shop_pro_account_bind".* FROM "shop_pro_account_bind" WHERE (pro_to > CURRENT_TIMESTAMP)
0.0017502307891846
Array
(
)
SELECT DISTINCT "contest_winners"."uid" FROM "contest_winners"
0.0048229694366455
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE (pid=592) AND (id!=93740) AND (status=1) ORDER BY "pdate" DESC
0.001007080078125
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 315334)))
0.0008549690246582
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =315334) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0007178783416748
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 339277)))
0.0010159015655518
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =339277) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0008389949798584
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 302507)))
0.0005028247833252
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =302507) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00097894668579102
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300365)))
0.00063204765319824
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300365) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00062012672424316
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 301784)))
0.00047397613525391
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =301784) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00086593627929688
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 322795)))
0.00067806243896484
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =322795) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00089097023010254
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 341126)))
0.00066804885864258
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =341126) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00062108039855957
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300085)))
0.00048303604125977
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300085) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010108947753906
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 325947)))
0.0004889965057373
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =325947) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00071501731872559
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300075)))
0.00062799453735352
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300075) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00065207481384277
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300267)))
0.00046896934509277
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300267) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00098204612731934
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 305860)))
0.00069308280944824
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =305860) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00062108039855957
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 340526)))
0.0004730224609375
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =340526) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00065398216247559
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 326394)))
0.00044417381286621
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =326394) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00058889389038086
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 308934)))
0.00045180320739746
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =308934) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00087618827819824
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 337453)))
0.00046682357788086
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =337453) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00093698501586914
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300076)))
0.00056910514831543
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300076) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010101795196533
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 72)))
0.00065088272094727
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =72) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00061392784118652
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300308)))
0.00044417381286621
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300308) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00097799301147461
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 325084)))
0.00069093704223633
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =325084) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010838508605957
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300923)))
0.0008699893951416
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300923) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0011270046234131
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300340)))
0.00068902969360352
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300340) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00088906288146973
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 303971)))
0.00085997581481934
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =303971) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00091910362243652
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 314580)))
0.00068402290344238
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =314580) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00090289115905762
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300320)))
0.00084090232849121
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300320) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010809898376465
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300349)))
0.00067281723022461
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300349) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00085592269897461
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 335372)))
0.000823974609375
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =335372) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010659694671631
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300098)))
0.0006859302520752
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300098) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010230541229248
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 320739)))
0.00079798698425293
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =320739) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010709762573242
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300141)))
0.00068902969360352
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300141) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010688304901123
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 328139)))
0.00064396858215332
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =328139) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010929107666016
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 337459)))
0.00082516670227051
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =337459) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010280609130859
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300336)))
0.00067591667175293
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300336) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0020811557769775
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0063929557800293
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.0026469230651855
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC