нейминг для логистической компании

0.024599075317383

Array ( )

connect

0.0060110092163086

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

Array ( )

SELECT "contest_projects".* FROM "contest_projects" WHERE ((("contest_projects"."id" = 812)))

0.002532958984375

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

Array ( )

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

0.0025918483734131

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_work_vote_winners' AND n.nspname = 'boutique' ORDER BY a.attnum

0.0010349750518799

Array ( )

SELECT "contest_work_vote_winners".* FROM "boutique"."contest_work_vote_winners" WHERE (pid =812) ORDER BY "count" DESC LIMIT 4

0.00090789794921875

Array ( )

SELECT "contest_winners"."wid", "contest_winners"."uid", "contest_winners"."date" FROM "contest_winners" WHERE (pid=812)

0.0026161670684814

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

Array ( )

SELECT "contest_works".* FROM "contest_works" WHERE ((("contest_works"."id" = 177566)))

0.0028049945831299

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

Array ( )

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

0.0036139488220215

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

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300365)))

0.0030238628387451

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

Array ( )

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

0.0034849643707275

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

0.0009310245513916

Array ( )

SELECT "shop_pro_account_bind".* FROM "shop_pro_account_bind" WHERE (pro_to > CURRENT_TIMESTAMP)

0.002025842666626

Array ( )

SELECT DISTINCT "contest_winners"."uid" FROM "contest_winners"

0.011606216430664

Array ( )

SELECT "contest_works".* FROM "contest_works" WHERE (pid=812) AND (id!=177566) AND (status=1) ORDER BY "pdate" DESC

0.00092220306396484

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 327609)))

0.00066494941711426

Array ( )

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

0.0010209083557129

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 302057)))

0.00061702728271484

Array ( )

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

0.00082993507385254

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300076)))

0.00059795379638672

Array ( )

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

0.00063085556030273

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 320739)))

0.00060200691223145

Array ( )

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

0.0006401538848877

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 348728)))

0.00058293342590332

Array ( )

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

0.00063204765319824

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 302051)))

0.00055217742919922

Array ( )

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

0.00067400932312012

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 305268)))

0.00055408477783203

Array ( )

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

0.00060200691223145

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300085)))

0.00056099891662598

Array ( )

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

0.00076794624328613

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 301631)))

0.00076580047607422

Array ( )

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

0.00073909759521484

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 316407)))

0.00053095817565918

Array ( )

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

0.00069904327392578

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 303971)))

0.00054788589477539

Array ( )

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

0.00066781044006348

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 304217)))

0.00072813034057617

Array ( )

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

0.00070905685424805

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300088)))

0.00054192543029785

Array ( )

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

0.00067305564880371

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 348650)))

0.00053310394287109

Array ( )

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

0.00064516067504883

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 300501)))

0.00054502487182617

Array ( )

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

0.00059795379638672

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 316161)))

0.00054287910461426

Array ( )

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

0.00065493583679199

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 327256)))

0.00056695938110352

Array ( )

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

0.00067901611328125

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 325947)))

0.00055313110351562

Array ( )

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

0.00071096420288086

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE ((("accounts"."id" = 341932)))

0.00052189826965332

Array ( )

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

0.0010979175567627

Array ( )

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

0.0034570693969727

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

Array ( )

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