0.02625298500061

Array ( )

connect

0.0051510334014893

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

Array ( )

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

0.00071907043457031

Array ( )

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

0.002295970916748

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

Array ( )

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

0.0042729377746582

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(301749,304130,305334,314097,342193,355899,360123,365352,388635,390438,393366,425388) ) 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.0028698444366455

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

Array ( )

SELECT "accounts".* FROM "boutique"."accounts" WHERE (id IN (425388, 360123, 342193, 304130, 390438, 305334, 301749, 365352, 355899, 314097, 388635, 393366))

0.0060060024261475

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 (425388,360123,342193,304130,390438,305334,301749,365352,355899,314097,388635,393366) AND get_acc_status(writer) IN (2,6) AND deleted = false GROUP BY uid

0.0021538734436035

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

Array ( )

SELECT "service_kit".* FROM "boutique"."service_kit" WHERE (uid IN (425388, 360123, 342193, 304130, 390438, 305334, 301749, 365352, 355899, 314097, 388635, 393366)) AND (published IS TRUE) AND (deleted IS NULL) AND (approved IS NOT NULL) ORDER BY "uid" ASC, "id" ASC

0.0020420551300049

Array ( )

SELECT uid, tagline, slogan FROM about WHERE uid IN (425388,360123,342193,304130,390438,305334,301749,365352,355899,314097,388635,393366)

0.00053000450134277

Array ( )

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

0.00088405609130859

Array ( )

SELECT uid, url_alias FROM user_url WHERE uid IN (425388,360123,342193,304130,390438,305334,301749,365352,355899,314097,388635,393366) AND active IS true ORDER BY create_date DESC

0.0019350051879883

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

Array ( )

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

0.0013539791107178

Array ( )

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

0.0022599697113037

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

Array ( )

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

0.0017421245574951

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

Array ( )

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