Конкурсы

0.027464866638184

Array ( )

connect

0.0070250034332275

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.001594066619873

Array ( )

SELECT COUNT(1) AS "zend_paginator_row_count" FROM "contest_projects" WHERE (status=2) AND (get_acc_type(uid)!=1) AND (spec=12)

0.19178485870361

Array ( )

SELECT contests.spec, CEIL((works_cnt *1.2)/contests_cnt) AS cnt FROM ( SELECT cp.spec, count(cw.id) AS works_cnt FROM contest_works AS cw LEFT JOIN contest_projects AS cp ON cp.id = cw.pid WHERE age(cw.pdate) < INTERVAL '1 year' group by cp.spec ) AS works LEFT JOIN ( SELECT cp.spec, count(cp.id) AS contests_cnt FROM contest_projects AS cp WHERE age(cp.pdate) < INTERVAL '1 year' group by cp.spec ) AS contests ON contests.spec = works.spec

0.029694080352783

Array ( )

SELECT COUNT(uid) as winners_total FROM contest_winners WHERE get_acc_status(uid) = 2

0.0092639923095703

Array ( )

SELECT "cp"."id" FROM "contest_projects" AS "cp" LEFT JOIN "contest_winners" AS "cw" ON cp.id = cw.pid WHERE (cp.status IN(4,10)) AND (get_acc_status(cw.uid) = 2) AND (cp.spec = 12) ORDER BY cw.date DESC LIMIT 3

0.00094795227050781

Array ( )

SELECT wid, pid FROM contest_winners WHERE pid IN (2991,2990,2989)

0.00069999694824219

Array ( )

SELECT id FROM contest_works WHERE id IN (898314,898481,898472)

0.0013549327850342

Array ( )

SELECT "contest_projects".* FROM "contest_projects" WHERE (id IN (2989,2990,2991))

0.0041558742523193

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.0014269351959229

Array ( )

SELECT "contest_specs".* FROM "contest_specs" WHERE (id IN (9,16,17,13))

0.0005950927734375

Array ( )

SELECT wid, uid, pid, date FROM contest_winners WHERE pid IN (2989,2990,2991)

0.00097298622131348

Array ( )

SELECT * FROM contest_works WHERE id IN (898314,898481,898472)

0.0032877922058105

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.0015630722045898

Array ( )

SELECT * FROM accounts WHERE id=371903 OR id=386953 OR id=400294

0.0050840377807617

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.0044200420379639

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.0043580532073975

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.0034618377685547

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.0010759830474854

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =371903) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.001011848449707

Array ( )

SELECT "contest_specs".* FROM "contest_specs" WHERE ((("contest_specs"."id" = 12)))

0.00064492225646973

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =386953) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.00050687789916992

Array ( )

SELECT "user_url".* FROM "boutique"."user_url" WHERE (uid =400294) AND (active IS true) ORDER BY "create_date" DESC LIMIT 1

0.0034182071685791

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_statuses' ORDER BY a.attnum

0.00063991546630859

Array ( )

SELECT "contest_statuses".* FROM "contest_statuses" WHERE ((("contest_statuses"."id" = 2)))

0.00055480003356934

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (status=3)

0.00055098533630371

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (status=4)

0.00071597099304199

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (status=10)

0.00051188468933105

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (status=2)

0.00048398971557617

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=5) AND (status=2)

0.0005028247833252

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=16) AND (status=2)

0.00043606758117676

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=9) AND (status=2)

0.00049710273742676

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=12) AND (status=2)

0.00049805641174316

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=18) AND (status=2)

0.00051999092102051

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=17) AND (status=2)

0.0004429817199707

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=13) AND (status=2)

0.00053215026855469

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=19) AND (status=2)

0.00050187110900879

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=20) AND (status=2)

0.00055193901062012

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=21) AND (status=2)

0.00051689147949219

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=22) AND (status=2)

0.00052595138549805

Array ( )

SELECT COUNT(1) FROM "contest_projects" WHERE (status IS NOT NULL) AND (spec=23) AND (status=2)

0.00098085403442383

Array ( )

SELECT "contest_projects".* FROM "contest_projects" WHERE (status=2) AND (get_acc_type(uid)!=1) AND (spec=12) ORDER BY "fdate" ASC LIMIT 1000

0.0014510154724121

Array ( )

SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime

0.0050649642944336

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.0022368431091309

Array ( )

SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC