SELECT COUNT(1) AS "zend_paginator_row_count" FROM "contest_projects" AS "cp"
LEFT JOIN "contest_winners" AS "cw" ON cw.pid = cp.id
LEFT JOIN "contest_works" AS "work" ON work.id = cw.wid WHERE (cp.status IN(4, 10)) AND (work.id IS NOT NULL) AND (get_acc_status(cw.uid) IN(2,6))
0.033317804336548
Array
(
)
SELECT "cp"."id" AS "contest_id", "cw"."uid" AS "user_id", "cw"."wid" AS "work_id" FROM "contest_projects" AS "cp"
LEFT JOIN "contest_winners" AS "cw" ON cw.pid = cp.id
LEFT JOIN "contest_works" AS "work" ON work.id = cw.wid WHERE (cp.status IN(4, 10)) AND (work.id IS NOT NULL) AND (get_acc_status(cw.uid) IN(2,6)) ORDER BY "cw"."date" DESC LIMIT 16 OFFSET 1248
0.0055108070373535
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.0011539459228516
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1557)))
0.00097393989562988
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1557)
0.0029330253601074
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.00087690353393555
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 443730)))
0.0032880306243896
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.0011169910430908
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 304382)))
0.0029759407043457
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.0010578632354736
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =304382) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010209083557129
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1557)))
0.0030288696289062
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.0011570453643799
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 13)))
0.0011210441589355
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1532)))
0.0007929801940918
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1532)
0.00053310394287109
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 436514)))
0.00061297416687012
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 337321)))
0.00049304962158203
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =337321) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00059223175048828
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1532)))
0.00067591667175293
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1565)))
0.00044608116149902
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1565)
0.00052595138549805
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 445042)))
0.00055193901062012
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 375231)))
0.00049805641174316
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =375231) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00058889389038086
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1565)))
0.00074005126953125
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 12)))
0.00052499771118164
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1552)))
0.00040888786315918
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1552)
0.00045013427734375
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 440825)))
0.00061488151550293
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 373985)))
0.00048398971557617
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =373985) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00052094459533691
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1552)))
0.00060009956359863
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 9)))
0.00053095817565918
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1546)))
0.00049901008605957
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1546)
0.00047612190246582
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 441670)))
0.00059413909912109
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 329191)))
0.00046801567077637
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =329191) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00053906440734863
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1546)))
0.00046896934509277
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1551)))
0.00044417381286621
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1551)
0.00060606002807617
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 441905)))
0.00053191184997559
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 311153)))
0.00047898292541504
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =311153) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00048685073852539
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1551)))
0.00048303604125977
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1539)))
0.00046396255493164
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1539)
0.00052404403686523
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 433569)))
0.00059199333190918
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 319451)))
0.00047206878662109
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =319451) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00051593780517578
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1539)))
0.00048398971557617
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1534)))
0.00046300888061523
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1534)
0.0005028247833252
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 434949)))
0.00060391426086426
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 312674)))
0.00047612190246582
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =312674) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00052499771118164
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1534)))
0.00069689750671387
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1543)))
0.00038695335388184
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1543)
0.00046205520629883
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 438476)))
0.00052595138549805
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 368143)))
0.00046801567077637
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =368143) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055098533630371
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1543)))
0.00051188468933105
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1547)))
0.00044512748718262
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1547)
0.00045609474182129
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 439530)))
0.00055193901062012
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1547)))
0.0006258487701416
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1540)))
0.00048589706420898
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1540)
0.00048184394836426
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 433167)))
0.00059294700622559
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 302835)))
0.00046896934509277
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =302835) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00053286552429199
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1540)))
0.00051498413085938
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1537)))
0.00042009353637695
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1537)
0.00051307678222656
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 438800)))
0.00055503845214844
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 303448)))
0.00050902366638184
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =303448) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055813789367676
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1537)))
0.00057101249694824
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1527)))
0.00037693977355957
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1527)
0.0004570484161377
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 425163)))
0.00066614151000977
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300098)))
0.00044012069702148
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300098) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005500316619873
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1527)))
0.0005040168762207
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 16)))
0.00057697296142578
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1482)))
0.00044894218444824
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1482)
0.00048303604125977
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 414978)))
0.0006859302520752
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 372589)))
0.00050711631774902
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =372589) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00056290626525879
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1482)))
0.00048708915710449
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 18)))
0.00084018707275391
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1523)))
0.00051283836364746
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1523)
0.00062704086303711
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 423554)))
0.00093388557434082
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 325003)))
0.0006561279296875
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =325003) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00068497657775879
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1523)))
0.00064897537231445
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1528)))
0.00051093101501465
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1528)
0.0006110668182373
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 427872)))
0.00072598457336426
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 96)))
0.0006101131439209
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =96) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00060701370239258
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1528)))
0.0014619827270508
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0044689178466797
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.0021119117736816
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC
