SHARE
TWEET

Untitled

a guest Jun 22nd, 2014 202 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. LOG:  durée : 103777.471 ms  exécute <unnamed>: SELECT "_C1" FROM (SELECT "hierarchy"."id" AS "_C1", TS_RANK_CD(NX_TO_TSVECTOR("fulltext"."fulltext"), TO_TSQUERY('english', $1), 32) AS _nxscore FROM "hierarchy" JOIN "fulltext" ON "fulltext"."id" = "hierarchy"."id" LEFT JOIN "misc" "_F1" ON "hierarchy"."id" = "_F1"."id" WHERE (("hierarchy"."primarytype" IN ($2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52)) AND ((TO_TSQUERY('english', $53) @@ NX_TO_TSVECTOR("fulltext"."fulltext"))) AND ("hierarchy"."isversion" IS NULL) AND ("_F1"."lifecyclestate" <> $54)) UNION ALL SELECT "_H"."id" AS "_C1", TS_RANK_CD(NX_TO_TSVECTOR("fulltext"."fulltext"), TO_TSQUERY('english', $55), 32) AS _nxscore FROM "hierarchy" "_H" JOIN "proxies" ON "_H"."id" = "proxies"."id" JOIN "hierarchy" ON "proxies"."targetid" = "hierarchy"."id" JOIN "fulltext" ON "fulltext"."id" = "hierarchy"."id" LEFT JOIN "misc" "_F1" ON "hierarchy"."id" = "_F1"."id" WHERE (("hierarchy"."primarytype" IN ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106)) AND ((TO_TSQUERY('english', $107) @@ NX_TO_TSVECTOR("fulltext"."fulltext"))) AND ("_H"."isversion" IS NULL) AND ("_F1"."lifecyclestate" <> $108))) AS "_T" ORDER BY _nxscore DESC LIMIT 21 OFFSET 0
  2. DÃTAIL:  paramètres : $1 = 'zim%:*', $2 = 'SectionRoot', $3 = 'ImportRoot', $4 = 'Workspace', $5 = 'RelationSearch', $6 = 'convention_cellule_juridique', $7 = 'user_open_tasks_cv', $8 = 'NewsItem', $9 = 'convention_dpl', $10 = 'convention_folder', $11 = 'FacetedSavedSearchesFolder', $12 = 'Thread', $13 = 'TemplateRoot', $14 = 'SocialDomain', $15 = 'DocumentRouteStep', $16 = 'cvt_ws', $17 = 'Domain', $18 = 'WorkspaceRoot', $19 = 'SocialWorkspace', $20 = 'ImportSet', $21 = 'QueryNav', $22 = 'SimpleTask', $23 = 'ConditionalTask', $24 = 'VEVENT', $25 = 'Video', $26 = 'convention_ri', $27 = 'MailMessage', $28 = 'Forum', $29 = 'PictureBook', $30 = 'SocialFolder', $31 = 'convention_dred', $32 = 'AssetLibrary', $33 = 'FollowLifeCycleTransitionTask', $34 = 'PublishTask', $35 = 'Picture', $36 = 'shibbGroup', $37 = 'Document', $38 = 'Folder', $39 = 'FacetedSearch', $40 = 'ImportFolder', $41 = 'File', $42 = 'AdvancedSearch', $43 = 'Note', $44 = 'quota_heaviest_containers_cv', $45 = 'NewsItemsRoot', $46 = 'Article', $47 = 'Section', $48 = 'MailFolder', $49 = 'OrderedFolder', $50 = 'Audio', $51 = 'commande_iufm', $52 = 'BasicAuditSearch', $53 = 'zim%:*', $54 = 'deleted', $55 = 'zim%:*', $56 = 'SectionRoot', $57 = 'ImportRoot', $58 = 'Workspace', $59 = 'RelationSearch', $60 = 'convention_cellule_juridique', $61 = 'user_open_tasks_cv', $62 = 'NewsItem', $63 = 'convention_dpl', $64 = 'convention_folder', $65 = 'FacetedSavedSearchesFolder', $66 = 'Thread', $67 = 'TemplateRoot', $68 = 'SocialDomain', $69 = 'DocumentRouteStep', $70 = 'cvt_ws', $71 = 'Domain', $72 = 'WorkspaceRoot', $73 = 'SocialWorkspace', $74 = 'ImportSet', $75 = 'QueryNav', $76 = 'SimpleTask', $77 = 'ConditionalTask', $78 = 'VEVENT', $79 = 'Video', $80 = 'convention_ri', $81 = 'MailMessage', $82 = 'Forum', $83 = 'PictureBook', $84 = 'SocialFolder', $85 = 'convention_dred', $86 = 'AssetLibrary', $87 = 'FollowLifeCycleTransitionTask', $88 = 'PublishTask', $89 = 'Picture', $90 = 'shibbGroup', $91 = 'Document', $92 = 'Folder', $93 = 'FacetedSearch', $94 = 'ImportFolder', $95 = 'File', $96 = 'AdvancedSearch', $97 = 'Note', $98 = 'quota_heaviest_containers_cv', $99 = 'NewsItemsRoot', $100 = 'Article', $101 = 'Section', $102 = 'MailFolder', $103 = 'OrderedFolder', $104 = 'Audio', $105 = 'commande_iufm', $106 = 'BasicAuditSearch', $107 = 'zim%:*', $108 = 'deleted'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top