0.026507139205933

Array ( )

connect

0.0056939125061035

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

Array ( )

SELECT "specs".* FROM "boutique"."specs" WHERE ((("specs"."id" = 29)))

0.0012259483337402

Array ( )

SELECT "specs".* FROM "boutique"."specs" WHERE (id IN (117, 598, 69, 116, 40, 124, 593, 29, 4))

0.002856969833374

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

0.00087904930114746

Array ( )

SELECT "shop_catalog_top_bind".* FROM "shop_catalog_top_bind" WHERE (bind_to > CURRENT_TIMESTAMP)

0.0049231052398682

Array ( )

SELECT freelancer.* FROM ( SELECT DISTINCT acc.id AS uid, acc.last_act AS last_act, rating_boutique.rating, top_bind.sort AS top_bind_sort, pro_bind.uid IS NOT NULL AS is_pro, uspec.spec AS spec FROM accounts AS acc LEFT JOIN user_specs AS uspec ON acc.id = uspec.uid AND uspec.is_primary LEFT JOIN user_rating_boutique AS rating_boutique ON rating_boutique.uid = acc.id LEFT JOIN shop_catalog_top_bind AS top_bind ON top_bind.uid = acc.id LEFT JOIN shop_pro_account_bind AS pro_bind ON pro_bind.uid = acc.id WHERE acc.id IN(300112,300335,345248,373960,383817,385475,419388,433023) ) AS freelancer ORDER BY freelancer.top_bind_sort DESC NULLS LAST, freelancer.is_pro DESC NULLS LAST, freelancer.rating DESC NULLS LAST, freelancer.last_act DESC NULLS LAST, freelancer.uid LIMIT 100 OFFSET 0

0.0035500526428223

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

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE (id IN (373960, 433023, 419388, 300335, 345248, 300112, 383817, 385475))

0.0034289360046387

Array ( )

SELECT uid, COUNT(*) FILTER (WHERE ball > 0) AS positive, COUNT(*) FILTER (WHERE ball < 0) AS negative, COUNT(*) AS total FROM reviews WHERE uid IN (373960,433023,419388,300335,345248,300112,383817,385475) AND get_acc_status(writer) IN (2,6) AND deleted = false GROUP BY uid

0.0029609203338623

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

0.0027320384979248

Array ( )

SELECT "service_kit".* FROM "boutique"."service_kit" WHERE (uid IN (373960, 433023, 419388, 300335, 345248, 300112, 383817, 385475)) AND (published IS TRUE) AND (deleted IS NULL) AND (approved IS NOT NULL) ORDER BY "uid" ASC, "id" ASC

0.0018467903137207

Array ( )

SELECT uid, tagline, slogan FROM about WHERE uid IN (373960,433023,419388,300335,345248,300112,383817,385475)

0.00096702575683594

Array ( )

SELECT "specs".* FROM "boutique"."specs" WHERE (id IN (29, 40, 124, 117, 69))

0.0013928413391113

Array ( )

SELECT uid, url_alias FROM user_url WHERE uid IN (373960,433023,419388,300335,345248,300112,383817,385475) AND active IS true ORDER BY create_date DESC

0.0034010410308838

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

Array ( )

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

0.002683162689209

Array ( )

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

0.0057921409606934

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

Array ( )

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

0.0047180652618408

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

Array ( )

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