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.03105092048645
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 1264
0.004601001739502
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.00074005126953125
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1519)))
0.00052690505981445
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1519)
0.0026609897613525
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.00069713592529297
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 421183)))
0.0027821063995361
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.00078511238098145
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 301149)))
0.0022780895233154
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.0009000301361084
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =301149) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00060296058654785
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1519)))
0.0027611255645752
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.00074911117553711
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 16)))
0.00051999092102051
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1529)))
0.00038695335388184
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1529)
0.00049400329589844
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 431484)))
0.0007178783416748
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300292)))
0.00052881240844727
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300292) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005497932434082
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1529)))
0.00073003768920898
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 12)))
0.000579833984375
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1520)))
0.00048398971557617
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1520)
0.0005180835723877
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 420110)))
0.00062918663024902
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300372)))
0.00049805641174316
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300372) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00059103965759277
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1520)))
0.00050878524780273
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1512)))
0.00045990943908691
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1512)
0.0005340576171875
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 429222)))
0.00059890747070312
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 301621)))
0.00053906440734863
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =301621) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055694580078125
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1512)))
0.00063204765319824
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 5)))
0.0005948543548584
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1509)))
0.0055720806121826
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1509)
0.00093698501586914
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 429733)))
0.0010261535644531
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 310413)))
0.00081300735473633
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =310413) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00081896781921387
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1509)))
0.00064396858215332
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 13)))
0.00077104568481445
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1524)))
0.00052905082702637
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1524)
0.00061702728271484
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 431099)))
0.00073504447937012
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300377)))
0.00060892105102539
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300377) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00067591667175293
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1524)))
0.00095486640930176
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1522)))
0.0005650520324707
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1522)
0.00059413909912109
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 431742)))
0.0009310245513916
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 373402)))
0.0010910034179688
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =373402) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00094509124755859
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1522)))
0.00068092346191406
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1521)))
0.00055813789367676
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1521)
0.0006558895111084
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 420901)))
0.00081181526184082
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 303966)))
0.00066399574279785
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =303966) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00086498260498047
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1521)))
0.00089597702026367
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1515)))
0.00091195106506348
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1515)
0.0010271072387695
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 424178)))
0.0013020038604736
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 310741)))
0.00061297416687012
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =310741) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00062108039855957
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1515)))
0.00045585632324219
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1503)))
0.00033783912658691
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1503)
0.00041317939758301
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 424233)))
0.00053095817565918
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 372250)))
0.0004267692565918
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =372250) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005650520324707
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1503)))
0.00049400329589844
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 9)))
0.00052499771118164
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1505)))
0.00042605400085449
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1505)
0.00039887428283691
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 421154)))
0.00054287910461426
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 370626)))
0.00040602684020996
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =370626) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00056791305541992
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1505)))
0.00059819221496582
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1472)))
0.00033783912658691
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1472)
0.00045204162597656
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 415145)))
0.00047898292541504
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 308136)))
0.0004270076751709
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =308136) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00046801567077637
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1472)))
0.00052809715270996
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1508)))
0.00041604042053223
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1508)
0.00039911270141602
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 419704)))
0.00052714347839355
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 334441)))
0.00036096572875977
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =334441) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00053811073303223
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1508)))
0.00048995018005371
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1513)))
0.0003969669342041
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1513)
0.00048303604125977
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 415489)))
0.00050497055053711
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 336492)))
0.00047206878662109
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =336492) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055885314941406
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1513)))
0.00059795379638672
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1492)))
0.00041508674621582
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1492)
0.00042891502380371
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 413441)))
0.0010321140289307
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 365965)))
0.00061798095703125
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =365965) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00059819221496582
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1492)))
0.00060796737670898
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1502)))
0.00057601928710938
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=1502)
0.00068306922912598
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 418330)))
0.00073599815368652
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 301763)))
0.00042200088500977
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =301763) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055909156799316
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 1502)))
0.0012321472167969
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0025370121002197
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.00099301338195801
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC
