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.029772996902466
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 80
0.004831075668335
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.0012609958648682
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3409)))
0.00069904327392578
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3409)
0.0028908252716064
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.00083494186401367
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1038737)))
0.0030488967895508
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.0011160373687744
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 411969)))
0.0023701190948486
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.00098705291748047
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =411969) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00078105926513672
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3409)))
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 = 'contest_specs' ORDER BY a.attnum
0.00092291831970215
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 13)))
0.00088381767272949
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3408)))
0.00054097175598145
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3408)
0.00052285194396973
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1037554)))
0.00090813636779785
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 400672)))
0.00056695938110352
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =400672) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00065898895263672
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3408)))
0.00054693222045898
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3405)))
0.00064301490783691
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3405)
0.00082993507385254
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1037921)))
0.00094294548034668
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 389986)))
0.00097084045410156
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =389986) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00067591667175293
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3405)))
0.0011880397796631
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 9)))
0.00085902214050293
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3401)))
0.0008699893951416
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3401)
0.00093197822570801
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1036935)))
0.0012140274047852
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 316161)))
0.001288890838623
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =316161) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0010409355163574
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3401)))
0.0010600090026855
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 16)))
0.00082898139953613
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3404)))
0.00072979927062988
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3404)
0.00061798095703125
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1037454)))
0.00094914436340332
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 414925)))
0.00085091590881348
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =414925) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00081396102905273
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3404)))
0.00088906288146973
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3400)))
0.00053882598876953
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3400)
0.0006401538848877
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1035021)))
0.00077199935913086
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300150)))
0.00088214874267578
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300150) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0006721019744873
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3400)))
0.00073003768920898
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3402)))
0.00054407119750977
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3402)
0.00055694580078125
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1035841)))
0.00066399574279785
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 411817)))
0.00047183036804199
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =411817) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00054502487182617
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3402)))
0.00049114227294922
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3398)))
0.00042295455932617
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3398)
0.00047802925109863
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1034346)))
0.00059795379638672
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300307)))
0.00047993659973145
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =300307) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.0005040168762207
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3398)))
0.00056099891662598
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3397)))
0.00037503242492676
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3397)
0.00048708915710449
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1035336)))
0.00055289268493652
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 302807)))
0.00046801567077637
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =302807) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00047588348388672
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3397)))
0.00051212310791016
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3396)))
0.00044989585876465
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3396)
0.00042486190795898
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1033163)))
0.00067019462585449
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 430055)))
0.00053215026855469
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =430055) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00052094459533691
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3396)))
0.00052404403686523
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3395)))
0.0004730224609375
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3395)
0.00050616264343262
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1032739)))
0.00066995620727539
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 411306)))
0.00086116790771484
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =411306) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00057601928710938
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3395)))
0.00053596496582031
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3393)))
0.00046300888061523
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3393)
0.00044488906860352
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1032287)))
0.00069403648376465
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 396812)))
0.00056695938110352
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =396812) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00063681602478027
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3393)))
0.00087094306945801
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3391)))
0.00038695335388184
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3391)
0.00049400329589844
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1031770)))
0.00061798095703125
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3391)))
0.00079584121704102
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3389)))
0.00047111511230469
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3389)
0.00046300888061523
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1031217)))
0.00063300132751465
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 413443)))
0.00046110153198242
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =413443) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00060915946960449
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3389)))
0.0006709098815918
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3388)))
0.00048708915710449
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3388)
0.0006101131439209
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1031651)))
0.00066995620727539
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3388)))
0.00056600570678711
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3385)))
0.0006258487701416
Array
(
)
SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=3385)
0.00076007843017578
Array
(
)
SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 1030480)))
0.00084519386291504
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 428179)))
0.00070810317993164
Array
(
)
SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =428179) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1
0.00065398216247559
Array
(
)
SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 3385)))
0.0013210773468018
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
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 = 'specs' AND n.nspname = 'boutique' ORDER BY a.attnum
0.0011148452758789
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC
