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.028264999389648
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 1904
0.0045859813690186
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.0009310245513916
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 448)))
0.0006260871887207
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=448)
0.0027689933776855
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.00075602531433105
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 59756)))
0.0031969547271729
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.00084900856018066
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300088)))
0.0027861595153809
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.0011270046234131
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300088) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00087189674377441
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 448)))
0.0031988620758057
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.00083398818969727
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 16)))
0.00081801414489746
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 423)))
0.00049710273742676
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=423)
0.00051403045654297
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 58622)))
0.0010011196136475
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 115)))
0.00061917304992676
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =115) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00062894821166992
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 423)))
0.001025915145874
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 9)))
0.0011870861053467
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 407)))
0.0011260509490967
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=407)
0.0011208057403564
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 57361)))
0.0013809204101562
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 301695)))
0.00098490715026855
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =301695) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0012409687042236
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 407)))
0.001082181930542
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 13)))
0.0011031627655029
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 376)))
0.00076818466186523
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=376)
0.0005800724029541
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 53928)))
0.00094890594482422
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 318745)))
0.0011701583862305
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =318745) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00078201293945312
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 376)))
0.00069689750671387
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 422)))
0.00055813789367676
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=422)
0.00062108039855957
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 56007)))
0.00080204010009766
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300079)))
0.00065708160400391
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300079) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00069618225097656
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 422)))
0.00062394142150879
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 404)))
0.00055503845214844
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=404)
0.0006098747253418
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 57403)))
0.00071191787719727
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 316865)))
0.00065803527832031
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =316865) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00064396858215332
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 404)))
0.00073409080505371
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 12)))
0.00063610076904297
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 430)))
0.00055599212646484
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=430)
0.00059318542480469
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 57460)))
0.00069403648376465
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 430)))
0.00079989433288574
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 367)))
0.00053906440734863
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=367)
0.0005948543548584
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 47429)))
0.00088000297546387
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 367)))
0.00094509124755859
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 418)))
0.00057888031005859
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=418)
0.00060415267944336
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 58184)))
0.00076603889465332
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 330314)))
0.00062799453735352
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =330314) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00072598457336426
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 418)))
0.00081110000610352
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 416)))
0.00055384635925293
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=416)
0.00061202049255371
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 58183)))
0.00078797340393066
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300563)))
0.00064802169799805
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300563) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00076413154602051
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 416)))
0.00089001655578613
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 402)))
0.00054121017456055
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=402)
0.00066685676574707
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 53298)))
0.00098609924316406
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300228)))
0.00086307525634766
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300228) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00061798095703125
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 402)))
0.00049710273742676
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 390)))
0.00048685073852539
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=390)
0.00052714347839355
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 54904)))
0.00094103813171387
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 390)))
0.00079894065856934
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 400)))
0.00043296813964844
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=400)
0.00047612190246582
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 52023)))
0.0007789134979248
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 303868)))
0.00063514709472656
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =303868) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00060391426086426
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 400)))
0.0006718635559082
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 393)))
0.00053906440734863
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=393)
0.00058817863464355
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 53442)))
0.0006871223449707
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300148)))
0.00056886672973633
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300148) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00065898895263672
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 393)))
0.00063920021057129
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 17)))
0.00061297416687012
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 384)))
0.0005040168762207
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=384)
0.00067520141601562
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 54888)))
0.0007631778717041
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 314692)))
0.00058984756469727
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =314692) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00065302848815918
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 384)))
0.00062298774719238
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 396)))
0.00049495697021484
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=396)
0.00058579444885254
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 51027)))
0.00070810317993164
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 305790)))
0.00062298774719238
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =305790) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0006110668182373
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 396)))
0.0010299682617188
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0037260055541992
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.001816987991333
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC
