Конкурсы

0.025588989257812

Array ( )

connect

0.0065898895263672

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

Array ( )

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

0.16314196586609

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

Array ( )

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

0.0036289691925049

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 = 22) ORDER BY cw.date DESC LIMIT 3

0.00064706802368164

Array ( )

SELECT wid, pid FROM contest_winners WHERE pid IN (3296,3305,3300)

0.00078201293945312

Array ( )

SELECT id FROM contest_works WHERE id IN (1010986,1011613,1011276)

0.0012691020965576

Array ( )

SELECT "contest_projects".* FROM "contest_projects" WHERE (id IN (3305,3296,3300))

0.0033028125762939

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

Array ( )

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

0.00054097175598145

Array ( )

SELECT wid, uid, pid, date FROM contest_winners WHERE pid IN (3305,3296,3300)

0.00075101852416992

Array ( )

SELECT * FROM contest_works WHERE id IN (1010986,1011613,1011276)

0.0032620429992676

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

Array ( )

SELECT * FROM accounts WHERE id=376987 OR id=382443 OR id=424976

0.0039799213409424

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

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

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

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

Array ( )

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

0.00099301338195801

Array ( )

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

0.00072598457336426

Array ( )

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

0.00075602531433105

Array ( )

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

0.0033609867095947

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

Array ( )

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

0.00058794021606445

Array ( )

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

0.00054788589477539

Array ( )

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

0.00084400177001953

Array ( )

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

0.00058317184448242

Array ( )

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

0.00059103965759277

Array ( )

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

0.00048398971557617

Array ( )

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

0.00050115585327148

Array ( )

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

0.00045990943908691

Array ( )

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

0.00053906440734863

Array ( )

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

0.00054502487182617

Array ( )

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

0.0004730224609375

Array ( )

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

0.00042986869812012

Array ( )

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

0.00041913986206055

Array ( )

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

0.00041103363037109

Array ( )

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

0.00041294097900391

Array ( )

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

0.00048589706420898

Array ( )

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

0.00088906288146973

Array ( )

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

0.00089502334594727

Array ( )

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

0.0035719871520996

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

Array ( )

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