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.0010759830474854
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE ((("specs"."id" = 117)))
0.13609600067139
Array
(
)
SELECT DISTINCT works.uid
FROM contest_works AS works
LEFT JOIN contest_projects AS projects ON projects.id = works.pid
WHERE works.status = 1
AND ( projects.status = 4 OR projects.status = 10)
0.0021271705627441
Array
(
)
SELECT DISTINCT "contest_winners"."uid" FROM "contest_winners"
0.033887147903442
Array
(
)
SELECT DISTINCT uid
FROM
(
-- пользователи у кого есть типовые услуги и аватара икупле на аккаунт или размещение
SELECT srv.uid AS uid
FROM service_kit AS srv
LEFT JOIN accounts AS acc ON acc.id = srv.uid
-- LEFT JOIN user_specs AS uspec ON srv.uid = uspec.uid AND uspec.is_primary IS TRUE
LEFT JOIN shop_pro_account_bind AS pro_bind ON pro_bind.uid = srv.uid
LEFT JOIN shop_servicekit_pinfront_bind AS pin_bind ON pin_bind.uid = srv.uid
LEFT JOIN shop_avatar_place_bind AS avatar_bind ON avatar_bind.uid = srv.uid
WHERE
acc.status = 2 AND acc.avatar IS NOT NULL -- есть аватара
AND srv.published IS TRUE AND srv.deleted IS NULL -- есть типовые услуги
AND
(
avatar_bind.bind_to > NOW() OR pin_bind.pinfront_to > NOW() OR pro_bind.pro_to > NOW() -- есть PRO или автара на главной или услуга на глагне
OR srv.uid IN(11,31,37,48,49,69,70,71,72,82,83,84,85,87,90,91,92,93,96,101,114,115,116,117,118,119,120,121,129,300018,300051,300066,300067,300068,300070,300071,300072,300073,300075,300076,300079,300084,300085,300087,300088,300091,300093,300096,300098,300099,300101,300103,300105,300108,300109,300112,300114,300116,300117,300124,300127,300128,300134,300135,300138,300141,300142,300144,300146,300147,300148,300150,300152,300154,300155,300159,300161,300166,300167,300173,300179,300183,300187,300188,300189,300190,300193,300195,300196,300198,300199,300203,300206,300208,300210,300212,300214,300216,300220,300221,300224,300227,300228,300229,300237,300240,300241,300255,300256,300257,300259,300260,300263,300266,300267,300269,300272,300276,300278,300281,300283,300292,300297,300298,300307,300308,300312,300314,300319,300320,300325,300326,300329,300331,300335,300336,300338,300339,300340,300341,300347,300349,300354,300355,300356,300357,300358,300362,300365,300367,300368,300372,300377,300378,300380,300381,300387,300390,300393,300394,300395,300398,300401,300402,300404,300408,300414,300415,300425,300449,300450,300451,300452,300470,300476,300479,300501,300505,300511,300526,300528,300554,300560,300563,300565,300589,300590,300659,300666,300683,300711,300758,300763,300766,300767,300777,300780,300802,300816,300823,300849,300859,300860,300865,300867,300879,300923,300926,300938,300961,301023,301037,301040,301050,301055,301068,301077,301086,301088,301103,301115,301141,301149,301150,301160,301161,301162,301163,301166,301176,301180,301184,301189,301197,301198,301206,301224,301229,301281,301297,301309,301316,301319,301323,301332,301341,301352,301359,301374,301393,301403,301408,301414,301460,301492,301505,301527,301533,301552,301558,301572,301578,301591,301621,301624,301631,301645,301649,301650,301661,301672,301675,301678,301681,301686,301695,301698,301706,301708,301729,301730,301732,301749,301752,301753,301763,301769,301781,301783,301784,301788,301793,301815,301881,301883,301891,301902,301916,301919,301929,301953,301959,301970,302010,302031,302048,302051,302057,302063,302069,302094,302105,302115,302144,302163,302215,302261,302265,302282,302293,302307,302325,302329,302330,302340,302343,302346,302361,302366,302377,302378,302390,302413,302415,302423,302426,302433,302437,302443,302454,302458,302460,302461,302483,302489,302495,302502,302507,302556,302560,302586,302596,302618,302656,302662,302671,302674,302708,302724,302727,302732,302735,302744,302748,302765,302766,302767,302769,302791,302792,302793,302807,302815,302820,302835,302857,302883,302918,302950,302960,302962,302969,302976,303009,303013,303016,303022,303049,303054,303061,303066,303074,303075,303097,303101,303107,303119,303131,303146,303167,303173,303175,303190,303195,303198,303202,303206,303220,303223,303250,303270,303281,303297,303312,303327,303353,303359,303394,303402,303406,303421,303435,303448,303474,303489,303495,303512,303528,303584,303593,303603,303605,303615,303623,303626,303656,303682,303686,303691,303704,303733,303748,303766,303782,303788,303810,303823,303834,303840,303855,303868,303881,303882,303947,303956,303966,303971,304003,304019,304024,304046,304078,304099,304130,304132,304154,304168,304184,304191,304217,304225,304241,304255,304262,304290,304305,304356,304382,304404,304407,304464,304481,304509,304532,304546,304564,304579,304591,304632,304644,304661,304681,304695,304740,304743,304768,304786,304787,304814,304827,304829,304853,304888,304905,304930,304971,304994,305000,305012,305035,305040,305071,305073,305093,305096,305115,305185,305237,305238,305260,305268,305273,305300,305303,305305,305317,305329,305334,305338,305353,305412,305415,305433,305434,305476,305601,305617,305669,305692,305726,305766,305789,305790,305808,305842,305860,305871,305881,305902,305903,305956,306027,306094,306132,306236,306238,306312,306314,306330,306368,306386,306429,306466,306468,306514,306539,306554,306675,306700,306763,306809,306819,306880,306915,306941,306944,306990,307014,307213,307290,307309,307353,307425,307457,307480,307500,307519,307569,307714,307728,307765,307792,307795,307825,307855,307865,307871,307872,307879,307972,307975,307992,308018,308024,308028,308043,308077,308104,308116,308136,308229,308277,308286,308372,308423,308521,308551,308559,308561,308582,308595,308640,308667,308671,308800,308808,308823,308849,308857,308869,308920,308934,308953,309003,309017,309032,309074,309078,309149,309213,309223,309234,309318,309393,309573,309593,309595,309627,309675,309683,309689,309742,309756,309765,309770,309780,309783,309801,309837,309896,309975,309983,310037,310087,310124,310140,310195,310198,310210,310290,310299,310310,310413,310461,310590,310599,310615,310616,310741,310792,310799,310804,310809,310866,310874,311153,311320,311358,311387,311392,311428,311561,311566,311640,311645,311744,311766,311960,311967,311988,312052,312057,312139,312240,312311,312393,312413,312436,312465,312587,312648,312667,312674,312804,312818,312937,312972,312978,313007,313329,313357,313398,313413,313494,313526,313609,313714,313795,313801,313804,313837,313847,313976,314016,314079,314097,314114,314130,314133,314173,314356,314409,314455,314506,314526,314580,314666,314692,314749,314772,314779,314848,315011,315043,315273,315283,315322,315334,315403,315453,315744,315839,315865,315873,315981,315984,316045,316096,316142,316161,316174,316302,316311,316318,316348,316407,316457,316469,316490,316529,316650,316759,316770,316859,316865,316907,317040,317080,317117,317229,317239,317515,317746,317789,317790,317844,317848,317869,317896,317907,317949,317956,317999,318049,318245,318280,318403,318562,318592,318644,318650,318704,318725,318745,318746,318747,318882,318980,319020,319077,319194,319439,319442,319451,319488,319506,319586,319600,319656,319666,319703,319735,319874,319934,319969,319970,319982,320015,320260,320268,320284,320313,320369,320370,320374,320387,320416,320419,320536,320555,320629,320713,320733,320739,320815,320827,320940,320975,320989,321015,321032,321040,321257,321530,321577,321693,321730,321763,321810,321882,321896,321914,321934,321939,321960,321967,321984,322014,322159,322239,322247,322323,322358,322445,322518,322579,322629,322781,322782,322795,322869,322933,323127,323222,323483,323559,323722,323744,323749,323807,323816,323836,323935,324127,324130,324238,324241,324287,324302,324555,324567,324620,324704,324731,324784,324905,325003,325084,325278,325429,325627,325642,325825,325837,325861,325885,325947,325978,326045,326134,326212,326234,326274,326306,326392,326394,326401,326450,326500,326608,326625,327013,327031,327057,327149,327256,327307,327346,327381,327400,327466,327584,327604,327609,328139,328210,328423,328425,328434,328485,328578,328716,328801,328826,328927,329028,329041,329065,329191,329268,329412,329505,329515,329576,329696,329826,330015,330089,330120,330139,330168,330314,330549,330583,330613,330640,330699,330751,330779,330839,330870,330941,330973,331089,331426,331464,331546,331732,331769,331905,331924,331947,331994,332175,332219,332233,332354,332607,332788,332827,332936,333119,333169,333286,333324,333425,333490,333544,333559,333605,333649,333653,333711,333737,333766,333846,333886,333931,334062,334114,334151,334176,334203,334221,334441,334483,334781,334832,335169,335180,335372,335434,335672,335936,335946,335961,335968,336076,336100,336209,336258,336336,336389,336492,336552,336591,336626,336725,336756,336865,336870,337050,337059,337182,337288,337321,337367,337399,337428,337429,337453,337459,337483,337635,337716,337775,337979,337994,337995,338030,338140,338348,338379,338438,338464,338478,338513,338564,338573,338718,338895,339049,339062,339150,339185,339277,339308,339359,339364,339365,339380,339510,339554,339565,339667,339882,339902,339921,339961,340018,340173,340208,340301,340304,340467,340511,340526,340544,340549,340550,340635,340721,340753,340845,340915,340960,341126,341127,341138,341141,341147,341217,341261,341311,341348,341365,341374,341397,341406,341450,341536,341543,341664,341739,341766,341792,341815,341837,341850,341859,341893,341899,341905,341926,341932,342009,342073,342087,342126,342152,342233,342330,342359,342424,342484,342500,342531,342653,342773,342808,342873,342886,342940,342943,342945,342953,342968,342979,343018,343095,343116,343147,343149,343240,343255,343265,343288,343472,343543,343631,343668,343687,343753,343825,343933,343972,344183,344239,344261,344329,344405,344435,344445,344452,344455,344530,344532,344630,344710,344730,344763,344826,344857,344875,344903,345014,345062,345106,345248,345373,345422,345496,345543,345624,345694,345713,345763,345780,345787,345803,345891,345964,346209,346316,346341,346384,346514,346563,346611,346699,346726,346841,346956,347127,347134,347260,347307,347369,347391,347490,347509,347534,347635,347682,347757,347760,347791,347811,347863,348024,348080,348097,348116,348243,348249,348302,348484,348519,348649,348650,348655,348661,348670,348689,348711,348728,348820,348906,348940,348980,349060,349115,349166,349206,349356,349398,349402,349545,349600,349602,349694,349727,349782,349853,349915,349974,350035,350066,350259,350326,350327,350336,350441,350524,350565,350651,350695,350723,351015,351026,351060,351113,351118,351184,351256,351301,351319,351393,351425,351492,351493,351611,351694,351715,351734,351831,351871,351939,351967,352051,352057,352170,352177,352208,352217,352233,352616,352665,352733,352735,352773,352775,352884,352889,352952,353024,353112,353361,353409,353466,353470,353572,353736,353824,353854,353885,353916,353996,353998,354077,354084,354109,354123,354139,354370,354384,354442,354483,354536,354671,354711,354768,354840,355018,355123,355140,355154,355163,355234,355279,355307,355430,355615,355639,355791,355819,355899,355959,356017,356188,356210,356316,356317,356355,356460,356479,356568,356756,356813,356841,356889,356925,356971,356974,357011,357081,357178,357199,357273,357279,357291,357329,357384,357510,357599,357665,357710,357757,357841,357852,357908,357939,357966,357975,357984,358021,358032,358042,358109,358188,358237,358260,358366,358375,358388,358392,358497,358554,358702,358781,358817,358823,358885,358955,359038,359060,359077,359161,359259,359371,359461,359482,359574,359698,359699,359802,359901,359927,359931,359977,360064,360078,360124,360243,360267,360284,360303,360310,360388,360445,360457,360502,360509,360550,360608,360724,360811,360877,360958,361058,361091,361290,361435,361449,361591,361641,361650,361659,361683,361717,361744,361896,361955,361965,362015,362019,362085,362110,362175,362259,362335,362351,362437,362485,362515,362585,362619,362748,362750,362770,362791,362904,362983,363033,363054,363171,363184,363297,363439,363459,363501,363555,363588,363589,363599,363613,363643,363723,363791,363913,363998,364030,364355,364565,364569,364573,364593,364607,364623,364714,364736,364799,364823,364921,365003,365013,365118,365218,365261,365284,365305,365307,365311,365352,365394,365398,365504,365541,365580,365632,365965,366048,366053,366100,366127,366230,366254,366302,366422,366508,366511,366532,366587,366637,366689,366723,366753,366939,366962,366973,366986,367039,367145,367161,367237,367254,367271,367272,367382,367537,367610,367625,367630,367693,367707,367802,367891,367918,367999,368058,368110,368143,368197,368202,368381,368390,368430,368551,368566,368576,368599,368609,368633,368640,368800,368805,368819,368853,368876,368943,368944,368958,368967,368979,368990,369031,369055,369110,369122,369151,369153,369199,369242,369279,369288,369338,369340,369382,369429,369448,369572,369594,369654,369676,369732,369733,369756,369759,369792,369794,369815,369847,369857,370011,370047,370088,370213,370354,370426,370440,370485,370495,370509,370513,370533,370561,370626,370655,370668,370669,370751,370807,370871,370884,370891,370895,370969,371124,371128,371185,371224,371225,371244,371254,371344,371359,371360,371370,371372,371383,371410,371415,371471,371508,371510,371511,371547,371668,371684,371722,371785,371832,371851,371903,371938,372039,372048,372063,372065,372078,372098,372130,372198,372250,372277,372304,372337,372367,372369,372401,372424,372425,372428,372435,372444,372453,372482,372537,372548,372573,372589,372615,372618,372633,372705,372727,372761,372800,372817,372838,372873,372891,372916,372919,372933,372935,372944,372958,372963,372971,373041,373058,373196,373237,373280,373290,373402,373450,373453,373479,373522,373541,373553,373600,373660,373674,373779,373816,373891,373897,373960,373979,373985,373994,374015,374131,374166,374179,374248,374263,374273,374304,374311,374344,374349,374373,374382,374465,374498,374530,374545,374741,374743,374779,374858,374878,374926,375007,375044,375049,375069,375106,375123,375129,375155,375208,375231,375305,375338,375350,375357,375374,375391,375435,375495,375589,375617,375710,375810,375884,375922,375925,375930,375944,375980,376016,376020,376025,376070,376073,376189,376191,376251,376257,376286,376292,376332,376386,376455,376467,376533,376548,376619,376638,376714,376731,376740,376756,376784,376823,376884,376918,376938,376961,376965,376969,376979,376981,376987,376996,376997,377000,377051,377096,377103,377115,377143,377169,377328,377376,377574,377575,377627,377633,377658,377668,377715,377734,377753,377770,377807,377844,377868,377928,377966,377982,378069,378104,378129,378259,378269,378283,378327,378435,378463,378537,378629,378645,378726,378792,378794,378797,378840,378913,378934,378978,378996,379000,379023,379025,379030,379067,379080,379112,379164,379183,379292,379346,379492,379498,379499,379571,379625,379662,379670,379690,379697,379717,379728,379749,379759,379818,379846,379880,379969,379989,380010,380051,380192,380244,380316,380332,380351,380361,380384,380413,380450,380536,380545,380553,380556,380664,380769,380775,380890,380908,380989,381022,381073,381194,381220,381262,381284,381297,381313,381350,381418,381498,381557,381559,381604,381688,381695,381794,381805,381819,381827,381839,381853,381913,381928,381953,381956,381967,381995,382007,382009,382090,382098,382126,382199,382205,382206,382261,382280,382315,382323,382343,382348,382354,382366,382378,382389,382433,382443,382468,382593,382612,382667,382688,382729,382809,382815,382878,382943,382996,383001,383067,383077,383095,383102,383131,383183,383197,383224,383255,383316,383365,383376,383443,383490,383655,383675,383694,383696,383702,383709,383732,383817,383823,383846,383897,383913,383925,384049,384055,384057,384091,384098,384140,384141,384144,384146,384163,384228,384351,384399,384419,384624,384709,384733,384754,384787,384792,384840,384864,384915,384965,384992,385006,385019,385042,385068,385205,385233,385322,385341,385372,385459,385475,385496,385695,385762,385821,385874,385882,385918,385933,385978,386019,386030,386036,386068,386153,386189,386193,386202,386226,386230,386320,386323,386329,386336,386350,386355,386470,386479,386489,386558,386629,386661,386687,386694,386696,386711,386747,386761,386806,386824,386850,386852,386862,386865,386896,386897,386906,386922,386941,386953,387038,387043,387057,387102,387107,387126,387150,387179,387206,387230,387265,387320,387363,387397,387421,387425,387503,387521,387622,387667,387671,387802,387951,388037,388088,388131,388148,388154,388203,388211,388238,388260,388289,388346,388465,388476,388488,388498,388519,388550,388620,388635,388642,388654,388664,388693,388718,388730,388760,388968,388970,389018,389029,389128,389129,389133,389156,389183,389193,389198,389203,389223,389240,389285,389293,389342,389360,389382,389392,389407,389563,389631,389646,389694,389817,389829,389865,389885,389938,389941,389978,389980,389986,390003,390009,390127,390285,390324,390338,390341,390355,390375,390451,390477,390489,390507,390512,390537,390545,390722,390763,390765,390767,390803,391091,391098,391146,391156,391158,391205,391481,391528,391611,391768,391830,391848,391906,392038,392121,392126,392210,392555,392586,392594,392627,392848,392874,392879,393022,393062,393063,393070,393152,393366,393416,393449,393648,393935,394046,394090,394192,394193,394277,394311,394325,394363,394475,394517,394650,394686,394923,394930,394935,395045,395092,395135,395141,395148,395407,395484,395528,395810,395922,395936,395944,396541,396713,396812,396817,396828,396855,396936,396948,396971,396994,397002,397059,397076,397169,397178,397848,397890,397932,397933,398092,398114,398139,398162,398449,398604,398661,398667,398689,398695,399152,399157,399225,399354,399355,399367,399379,399492,399500,399601,399650,399668,399683,399685,399754,399783,399789,399816,399905,399934,399971,399983,400010,400034,400072,400138,400151,400216,400246,400294,400319,400333,400375,400437,400506,400537,400583,400594,400607,400608,400661,400672,400673,400690,400735,400875,400876,400879,400884,400939,400947,400948,401012,401037,401134,401165,401179,401200,401219,401252,401280,401282,401296,401328,401395,401429,401438,401470,401538,401581,401596,401724,401754,401790,401812,401868,401945,401994,402067,402140,402180,402238,402265,402292,402399,402415,402437,402446,402477,402491,402544,402587,402602,402623,402707,402714,402747,402754,402812,402830,402838,402938,402975,402981,402999,403103,403112,403142,403172,403282,403284,403294,403300,403332,403362,403420,403436,403480,403518,403549,403605,403606,403630,403670,403692,403733,403746,403780,403818,403895,403912,403918,403956,404180,404246,404373,404463,404472,404548,404574,404734,404741,404813,404924,404951,405108,405125,405151,405176,405610,405645,405659,405698,405704,405821,405830,405844,405851,405905,405912,405953,406035,406037,406045,406054,406069,406085,406148,406165,406172,406174,406184,406228,406257,406439,406586,406662,406996,407041,407290,407461,407471,407505,407541,407542,407592,407597,407878,407975,407991,407999,408099,408133,408601,408622,408627,409012,409052,409306,409313,409510,409514,409525,409732,410076,410083,410512,410530,410533,410601,410604,410671,410688,410776,410788,410797,410930,410946,410957,410962,410977,410980,411017,411028,411061,411170,411195,411275,411306,411354,411373,411404,411512,411527,411576,411592,411659,411755,411816,411817,411839,411875,411957,411969,412034,412124,412152,412181,412202,412223,412244,412272,412276,412277,412360,412451,412565,412586,412644,412722,412945,412955,413092,413132,413155,413201,413227,413293,413398,413399,413443,413483,413507,413515,413530,413532,413541,413547,413574,413591,413661,413777,413922,414117,414139,414147,414418,414435,414525,414925,415141,415145,415160,415208,415223,415231,415283,415285,415297,415316,415427,415591,415875,415878,416215,416534,416863,416949,417079,417086,417092,417257,417311,417566,417573,417807,417861,417966,418623,418720,418726,418790,418821,418829,419388,419611,420287,420330,420349,420392,420442,420750,421062,421128,421171,421192,421194,421201,421225,421267,421278,421285,421293,421295,421560,421578,421609,421610,421629,421654,421684,421693,421708,421710,421719,421811,421825,421833,421869,422074,422097,422176,422237,422425,422599,422804,423125,423688,423758,423779,423948,423972,424000,424005,424020,424046,424094,424102,424388,424394,424411,424427,424530,424799,424820,424849,424889,424938,424954,424957,424963,424966,424969,424976,425011,425087,425094,425330,425350,425514,425624,425721,425777,426211,426275,426416,426651,426708,426769,426866,427145,427157,427165,427175,427208,427240,427282,427500,427626,427634,427852,428014,428022,428058,428141,428179,428192,428219,428255,428296,428370,428495,428780,428838,428912,428934,428943,428953,428954,428966,428995,429000,429128,429155,429156,429257,429327,429412,429440,429462,429469,429628,429645,429690,429712,429742,429770,429846,429868,430027,430055,430118,430324,431042,431128,431144,431185,431188,431213,431406,431444,431470,431540,431616,431620,432167,432179,432349,432418,432420,432514,432597,432661,432664,432731,432772,432830,432850,432896,432932,433023,433079,433081,433123,433150,433154,433172,433187,433211,433260,433328,433432,433483,434004,434142,434341,434491,434503,434555,434691,434962,435162,435369,435400,435447,435513,435557,435582,435729,435787,435855,436373,436677,436693,436792,437020,437026,437067,437094,437230,437243,437343,437344,437354,437400,437475,437529,437597,437649,437664,437672,437694,437973,437997,438331,438346,438474,438584,438749,438759,438875,438960,439116,311166,10,413535,337620,317530,301439,343424) -- contest winner or shortlister
)
UNION -- подключен Услуга выше в каталоге
SELECT catalog_top_bind.uid AS uid
FROM shop_catalog_top_bind AS catalog_top_bind
-- LEFT JOIN user_specs ON user_specs.uid = catalog_top_bind.uid AND user_specs.is_primary IS TRUE
WHERE catalog_top_bind.bind_to > NOW()
AND get_acc_status(catalog_top_bind.uid) = 2
) AS freelancers
0.011162996292114
Array
(
)
SELECT us.uid, us.spec AS spec_id,
CASE WHEN us.is_primary IS TRUE THEN 1 ELSE 0 END AS is_primary
FROM user_specs us
WHERE us.uid IN (10,11,71,72,93,300079,300084,300085,300088,300112,300114,300127,300148,300166,300227,300276,300314,300319,300335,300358,300367,300372,300393,300402,300449,300926,301077,301184,301341,301352,301578,301631,301649,301749,302437,302443,302461,302495,302735,302766,302792,302883,303013,303202,303281,303603,303810,304024,304130,304695,304930,305040,305093,305329,305334,306027,306941,307879,309689,310413,310590,311320,314097,316490,318562,318980,319488,319666,320370,325084,325885,326212,328425,329191,329505,334151,334176,334441,334483,337483,342193,343095,343149,345248,345624,346209,346384,348024,349694,349782,350441,351015,351113,351150,352217,355819,355899,356813,359931,360123,360388,360811,360958,362748,363501,364714,365352,366723,367271,368958,371903,372838,373479,373600,373960,373985,374273,374779,375930,376455,376987,377143,377928,378259,378463,379025,379164,379625,379690,379697,379749,380384,381794,381827,382126,382205,382348,382443,383095,383696,383817,383897,384351,385019,385475,386355,386558,386906,386953,387206,387951,388088,388203,388635,389203,389885,389938,389986,390438,390803,391091,391098,392126,393366,395407,396812,396971,396994,398114,399152,399225,399650,399816,400246,400294,400375,400537,400672,401200,401328,401596,401754,402747,403294,403436,403692,403733,403780,404574,404741,404924,405176,405830,405912,406054,407505,407878,408099,410512,410530,410671,411170,411275,411306,411404,411592,411816,412034,412152,412181,412202,412223,412565,412586,412722,413155,413507,413541,414117,414925,415283,415285,415427,417257,418623,418720,419388,420392,420775,421062,421171,421293,421693,421833,422074,422425,422599,423779,423948,424046,424969,424976,425388,425514,426275,427157,427240,427282,427500,428179,428219,428255,428495,429086,429690,429742,431188,432179,432420,432661,433023,433079,433172,434142,434962,438474,438749,439076)
AND spec_parent(us.spec) = 1
ORDER BY us.uid, us.is_primary DESC
0.0010769367218018
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (id IN (117, 598, 69, 116, 40, 124, 593, 29, 4))
0.002708911895752
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.00063085556030273
Array
(
)
SELECT "shop_catalog_top_bind".* FROM "shop_catalog_top_bind" WHERE (bind_to > CURRENT_TIMESTAMP)
0.0035550594329834
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,72,300079,300085,300088,300112,300148,300314,300358,300367,300372,302443,304695,309689,334441,337483,343149,346384,349694,351113,352217,359931,360388,392126,418720,419388,420775,439076)
) 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.0033271312713623
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.0012710094451904
Array
(
)
SELECT "accounts".* FROM "boutique"."accounts" WHERE (id IN (439076, 420775, 304695, 360388, 72, 419388, 334441, 300367, 300358, 418720, 300372, 346384, 300088, 300085, 349694, 300112, 300148, 343149, 309689, 300314, 352217, 392126, 351113, 302443, 337483, 359931, 300079, 10))
0.0068950653076172
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 (439076,420775,304695,360388,72,419388,334441,300367,300358,418720,300372,346384,300088,300085,349694,300112,300148,343149,309689,300314,352217,392126,351113,302443,337483,359931,300079,10)
AND get_acc_status(writer) IN (2,6)
AND deleted = false
GROUP BY uid
0.004025936126709
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.0037751197814941
Array
(
)
SELECT "service_kit".* FROM "boutique"."service_kit" WHERE (uid IN (439076, 420775, 304695, 360388, 72, 419388, 334441, 300367, 300358, 418720, 300372, 346384, 300088, 300085, 349694, 300112, 300148, 343149, 309689, 300314, 352217, 392126, 351113, 302443, 337483, 359931, 300079, 10)) AND (published IS TRUE) AND (deleted IS NULL) AND (approved IS NOT NULL) ORDER BY "uid" ASC, "id" ASC
0.0055818557739258
Array
(
)
SELECT uid, tagline, slogan FROM about WHERE uid IN (439076,420775,304695,360388,72,419388,334441,300367,300358,418720,300372,346384,300088,300085,349694,300112,300148,343149,309689,300314,352217,392126,351113,302443,337483,359931,300079,10)
0.00098299980163574
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (id IN (117, 124, 29, 40, 69, 4, 598, 593, 116))
0.0020101070404053
Array
(
)
SELECT uid, url_alias FROM user_url WHERE uid IN (439076,420775,304695,360388,72,419388,334441,300367,300358,418720,300372,346384,300088,300085,349694,300112,300148,343149,309689,300314,352217,392126,351113,302443,337483,359931,300079,10) AND active IS true ORDER BY create_date DESC
0.003385066986084
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.000762939453125
Array
(
)
SELECT "shop_pro_account_bind".* FROM "shop_pro_account_bind" WHERE (pro_to > CURRENT_TIMESTAMP)
0.0022649765014648
Array
(
)
SELECT DISTINCT "contest_winners"."uid" FROM "contest_winners"
0.0055129528045654
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.0018389225006104
Array
(
)
SELECT "contest_specs".* FROM "contest_specs" WHERE ( disabled_finish_datetime
0.0024220943450928
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.00094318389892578
Array
(
)
SELECT "specs".* FROM "boutique"."specs" WHERE (parent=1) ORDER BY "prio" ASC, "name" ASC