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.029646158218384
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 624
0.0044319629669189
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.00093293190002441
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2566)))
0.00089502334594727
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2566)
0.0029060840606689
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.00062799453735352
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 774515)))
0.0029680728912354
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.0008699893951416
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 368143)))
0.0021800994873047
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.00089716911315918
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =368143) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00080704689025879
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2566)))
0.0025560855865479
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.00082492828369141
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 12)))
0.00068116188049316
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2572)))
0.00039100646972656
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2572)
0.00049495697021484
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 775487)))
0.00054693222045898
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 391098)))
0.0005028247833252
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =391098) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00045490264892578
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2572)))
0.00061416625976562
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 9)))
0.00067710876464844
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2565)))
0.00044608116149902
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2565)
0.00046491622924805
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 773611)))
0.00060582160949707
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 379625)))
0.00054407119750977
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =379625) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005648136138916
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2565)))
0.00057697296142578
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2570)))
0.0004580020904541
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2570)
0.00054311752319336
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 772575)))
0.00059294700622559
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300098)))
0.00054693222045898
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300098) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005488395690918
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2570)))
0.00061798095703125
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 16)))
0.00055098533630371
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2554)))
0.00045394897460938
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2554)
0.00056815147399902
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 774094)))
0.00060796737670898
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 399816)))
0.00051403045654297
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =399816) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00063490867614746
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2554)))
0.00053095817565918
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2560)))
0.00045585632324219
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2560)
0.00052881240844727
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 773840)))
0.00059795379638672
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 388088)))
0.00054192543029785
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =388088) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055289268493652
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2560)))
0.00051593780517578
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 18)))
0.00052618980407715
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2549)))
0.00044989585876465
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2549)
0.00053191184997559
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 773494)))
0.00059294700622559
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 367610)))
0.00054097175598145
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =367610) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00054311752319336
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2549)))
0.00056099891662598
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2547)))
0.00046992301940918
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2547)
0.00050497055053711
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 770550)))
0.00060892105102539
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 93)))
0.00047898292541504
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =93) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00058293342590332
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2547)))
0.00057506561279297
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2550)))
0.00040388107299805
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2550)
0.00048708915710449
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 768958)))
0.00058913230895996
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300079)))
0.00049805641174316
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300079) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00061893463134766
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2550)))
0.00057792663574219
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2546)))
0.00049209594726562
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2546)
0.00052905082702637
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 769628)))
0.0006251335144043
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 399225)))
0.00047588348388672
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =399225) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005650520324707
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2546)))
0.00058698654174805
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2552)))
0.00042295455932617
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2552)
0.00048995018005371
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 771526)))
0.00058507919311523
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 351831)))
0.00049400329589844
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =351831) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0006101131439209
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2552)))
0.0005650520324707
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2551)))
0.00046801567077637
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2551)
0.00048398971557617
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 770722)))
0.00061607360839844
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 318562)))
0.00054502487182617
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =318562) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055694580078125
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2551)))
0.00057411193847656
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2538)))
0.00050902366638184
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2538)
0.00054097175598145
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 770394)))
0.00060296058654785
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 340467)))
0.00050997734069824
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =340467) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00055813789367676
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2538)))
0.00054693222045898
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2544)))
0.00044989585876465
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2544)
0.00059914588928223
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 771166)))
0.00062704086303711
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 303066)))
0.00054192543029785
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =303066) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00054311752319336
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2544)))
0.00070595741271973
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 5)))
0.00047421455383301
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2542)))
0.00047898292541504
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2542)
0.00046491622924805
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 768663)))
0.0007779598236084
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 398667)))
0.00049710273742676
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =398667) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00052309036254883
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2542)))
0.00048494338989258
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2536)))
0.00045204162597656
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=2536)
0.00049710273742676
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 766899)))
0.00061917304992676
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 351113)))
0.00054717063903809
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =351113) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00054311752319336
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 2536)))
0.0012810230255127
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0044221878051758
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.001845121383667
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC
