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.0010261535644531
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE ((("specs"."id" = 598)))
0.0010731220245361
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (id IN (117, 598, 69, 116, 40, 124, 593, 29, 4))
0.0027740001678467
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.00060105323791504
Array
(
)
SELECT "shop_catalog_top_bind".* FROM "shop_catalog_top_bind" WHERE (bind_to > CURRENT_TIMESTAMP)
0.0055861473083496
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(10,71,300084,300166,300319,300372,302437,303013,303810,304024,306941,307879,310590,316490,318562,319488,334176,343095,345624,362748,379164,382348,387951,402747,426275,434962)
) 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.0030999183654785
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.0012199878692627
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE (id IN (306941, 316490, 434962, 426275, 387951, 300084, 303013, 310590, 300372, 300166, 402747, 302437, 304024, 303810, 71, 319488, 362748, 318562, 334176, 382348, 379164, 300319, 307879, 343095, 345624, 10))
0.0079319477081299
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 (306941,316490,434962,426275,387951,300084,303013,310590,300372,300166,402747,302437,304024,303810,71,319488,362748,318562,334176,382348,379164,300319,307879,343095,345624,10)
AND get_acc_status(writer) IN (2,6)
AND deleted = false
GROUP BY uid
0.0025889873504639
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.0026359558105469
Array
(
)
SELECT "service_kit".* FROM "boutique"."service_kit" WHERE (uid IN (306941, 316490, 434962, 426275, 387951, 300084, 303013, 310590, 300372, 300166, 402747, 302437, 304024, 303810, 71, 319488, 362748, 318562, 334176, 382348, 379164, 300319, 307879, 343095, 345624, 10)) AND (published IS TRUE) AND (deleted IS NULL) AND (approved IS NOT NULL) ORDER BY "uid" ASC, "id" ASC
0.0045318603515625
Array
(
)
SELECT uid, tagline, slogan FROM about WHERE uid IN (306941,316490,434962,426275,387951,300084,303013,310590,300372,300166,402747,302437,304024,303810,71,319488,362748,318562,334176,382348,379164,300319,307879,343095,345624,10)
0.00071310997009277
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (id IN (40, 124, 598, 69, 4, 117, 116))
0.0011529922485352
Array
(
)
SELECT uid, url_alias FROM user_url WHERE uid IN (306941,316490,434962,426275,387951,300084,303013,310590,300372,300166,402747,302437,304024,303810,71,319488,362748,318562,334176,382348,379164,300319,307879,343095,345624,10) AND active IS true ORDER BY create_date DESC
0.0023238658905029
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.00052285194396973
Array
(
)
SELECT "shop_pro_account_bind".* FROM "shop_pro_account_bind" WHERE (pro_to > CURRENT_TIMESTAMP)
0.0017490386962891
Array
(
)
SELECT DISTINCT "contest_winners"."uid" FROM "contest_winners"
0.0054678916931152
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.0022921562194824
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0047380924224854
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.0015048980712891
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC