Конкурсы

0.02532696723938

Array ( )

connect

0.0061051845550537

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

Array ( )

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

0.010485887527466

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

0.00058698654174805

Array ( )

SELECT wid, pid FROM contest_winners WHERE pid IN (3276,3187,3101)

0.00075984001159668

Array ( )

SELECT id FROM contest_works WHERE id IN (938672,973285,1004947)

0.00083804130554199

Array ( )

SELECT "contest_projects".* FROM "contest_projects" WHERE (id IN (3187,3101,3276))

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

0.00099897384643555

Array ( )

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

0.00053691864013672

Array ( )

SELECT wid, uid, pid, date FROM contest_winners WHERE pid IN (3187,3101,3276)

0.0010519027709961

Array ( )

SELECT * FROM contest_works WHERE id IN (938672,973285,1004947)

0.003162145614624

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

Array ( )

SELECT * FROM accounts WHERE id=300085 OR id=300075 OR id=415875

0.0035409927368164

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

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

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

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

Array ( )

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

0.0010299682617188

Array ( )

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

0.00071310997009277

Array ( )

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

0.0035820007324219

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

Array ( )

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

0.00074505805969238

Array ( )

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

0.00068497657775879

Array ( )

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

0.00091910362243652

Array ( )

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

0.00049495697021484

Array ( )

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

0.00056886672973633

Array ( )

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

0.00049781799316406

Array ( )

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

0.0005340576171875

Array ( )

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

0.00048112869262695

Array ( )

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

0.00052595138549805

Array ( )

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

0.00048279762268066

Array ( )

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

0.00051498413085938

Array ( )

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

0.0004730224609375

Array ( )

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

0.00053501129150391

Array ( )

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

0.00047922134399414

Array ( )

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

0.00052690505981445

Array ( )

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

0.00073099136352539

Array ( )

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

0.0010030269622803

Array ( )

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

0.0013298988342285

Array ( )

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

0.0045928955078125

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

Array ( )

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