Project:
| View Revisions: Issue #51089 | [ Back to Issue ] | ||
| Summary | 0051089: Slowness on some queries of the module | ||
| Revision | 2022-12-12 11:40 by aferraz | ||
| Steps To Reproduce | SELECT obpos_appl0_.EM_Obcfr_Isblockchained AS col_0_0_, coalesce(obcfrticke1_.Seqno, 0) AS col_1_0_, obcfrticke1_.Hash AS col_2_0_, '***' AS col_3_0_, ( SELECT coalesce(max(obcfr_bloc2_.Seqno), 0) FROM OBCFR_BlockchainIssue obcfr_bloc2_ WHERE obcfr_bloc2_.Entity = 'OBCFR_Ticket' AND coalesce(obcfr_bloc2_.Obpos_Applications_ID, obcfr_bloc2_.AD_Client_ID) = 'C5CBA19E2F6D492FBAD24041E7BC8286') AS col_4_0_ FROM OBPOS_APPLICATIONS obpos_appl0_ LEFT OUTER JOIN OBCFR_Ticket obcfrticke1_ ON obpos_appl0_.Obpos_Applications_ID = obcfrticke1_.Obpos_Applications_ID WHERE obpos_appl0_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286' AND coalesce(obcfrticke1_.Seqno, 0) = coalesce(( SELECT max(obcfr_tick3_.Seqno) FROM OBCFR_Ticket obcfr_tick3_ WHERE obcfr_tick3_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286'), 0); | ||
| Revision | 2022-12-12 08:56 by aferraz | ||
| Steps To Reproduce | SELECT obpos_appl0_.EM_Obcfr_Isblockchained AS col_0_0_, coalesce(obcfrticke1_.Seqno, 0) AS col_1_0_, obcfrticke1_.Hash AS col_2_0_, '342fdjks-fs_dsf_dfasdf+dfasf#dfsdf$ddsa df%dfd SE78/dfsdf*~ DsdsAPSnSWmsasw2xx2kqlduKksISMd poe$sa-Kysw784s80021s2 df--p1s0FINys2s~tar3oz' AS col_3_0_, ( SELECT coalesce(max(obcfr_bloc2_.Seqno), 0) FROM OBCFR_BlockchainIssue obcfr_bloc2_ WHERE obcfr_bloc2_.Entity = 'OBCFR_Ticket' AND coalesce(obcfr_bloc2_.Obpos_Applications_ID, obcfr_bloc2_.AD_Client_ID) = 'C5CBA19E2F6D492FBAD24041E7BC8286') AS col_4_0_ FROM OBPOS_APPLICATIONS obpos_appl0_ LEFT OUTER JOIN OBCFR_Ticket obcfrticke1_ ON obpos_appl0_.Obpos_Applications_ID = obcfrticke1_.Obpos_Applications_ID WHERE obpos_appl0_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286' AND coalesce(obcfrticke1_.Seqno, 0) = coalesce(( SELECT max(obcfr_tick3_.Seqno) FROM OBCFR_Ticket obcfr_tick3_ WHERE obcfr_tick3_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286'), 0); | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |