Skip to content

Instantly share code, notes, and snippets.

@dsadaka

dsadaka/gist:5874220

Created June 27, 2013 05:42
Show Gist options
  • Save dsadaka/5874220 to your computer and use it in GitHub Desktop.
Save dsadaka/5874220 to your computer and use it in GitHub Desktop.
Download ZIP
Too many db calls
Raw
gistfile1
INFO 01:39:27 ubuntu rails[4512]: Started GET "/po_hdrs" for 127.0.0.1 at 2013-06-27 01:39:27 -0400
INFO 01:39:27 ubuntu controllers[4512]: Processing by PoHdrsController#index as HTML
DEBUG 01:39:27 ubuntu models[4512]: User Load (90.2ms) EXEC sp_executesql N'SELECT TOP (1) [users].* FROM [users] WHERE [users].[id] = 6'
DEBUG 01:39:27 ubuntu models[4512]: Role Load (82.9ms) EXEC sp_executesql N'SELECT TOP (1) [roles].* FROM [roles] INNER JOIN [user_roles] ON [roles].[id] = [user_roles].[role_id] WHERE [user_roles].[user_id] = 6'
DEBUG 01:39:32 ubuntu models[4512]: SQL (5679.3ms) EXEC sp_executesql N'SELECT [dbo].[POHDRF00].[po_no] AS t0_r0, [dbo].[POHDRF00].[batch_no] AS t0_r1, [dbo].[POHDRF00].[usr_id] AS t0_r2, [dbo].[POHDRF00].[vend_no] AS t0_r3, [dbo].[POHDRF00].[alt_po_no] AS t0_r4, [dbo].[POHDRF00].[po_hdr_dat] AS t0_r5, [dbo].[POHDRF00].[alt_po_no_2] AS t0_r6, [dbo].[POHDRF00].[vend_nam] AS t0_r7, [dbo].[POHDRF00].[vend_loc_cod] AS t0_r8, [dbo].[POHDRF00].[vend_addr_1] AS t0_r9, [dbo].[POHDRF00].[vend_addr_2] AS t0_r10, [dbo].[POHDRF00].[vend_addr_3] AS t0_r11, [dbo].[POHDRF00].[vend_cntry] AS t0_r12, [dbo].[POHDRF00].[po_hdr_fob] AS t0_r13, [dbo].[POHDRF00].[po_hdr_ship_via] AS t0_r14, [dbo].[POHDRF00].[po_hdr_ord_by] AS t0_r15, [dbo].[POHDRF00].[po_hdr_spec_terms] AS t0_r16, [dbo].[POHDRF00].[po_hdr_deliv_to] AS t0_r17, [dbo].[POHDRF00].[confirm_flg] AS t0_r18, [dbo].[POHDRF00].[po_hdr_spec_msg] AS t0_r19, [dbo].[POHDRF00].[no_open_lins] AS t0_r20, [dbo].[POHDRF00].[no_clsd_lins] AS t0_r21, [dbo].[POHDRF00].[lst_chng_no] AS t0_r22, [dbo].[POHDRF00].[lst_chng_dat] AS t0_r23, [dbo].[POHDRF00].[lst_chng_user_id] AS t0_r24, [dbo].[POHDRF00].[po_hdr_prt_flg] AS t0_r25, [dbo].[POHDRF00].[po_hdr_cancel_flg] AS t0_r26, [dbo].[POHDRF00].[mult_drop_flg] AS t0_r27, [dbo].[POHDRF00].[blnkt_po_flg] AS t0_r28, [dbo].[POHDRF00].[blnkt_rel_no] AS t0_r29, [dbo].[POHDRF00].[blnkt_rel_dat] AS t0_r30, [dbo].[POHDRF00].[blnkt_rel_prd] AS t0_r31, [dbo].[POHDRF00].[blnkt_rel_no_prds] AS t0_r32, [dbo].[POHDRF00].[bill_vend_no] AS t0_r33, [dbo].[POHDRF00].[currency_cod] AS t0_r34, [dbo].[POHDRF00].[po_verifd] AS t0_r35, [dbo].[POHDRF00].[po_hdr_sls_ord_no] AS t0_r36, [dbo].[POHDRF00].[timestamp] AS t0_r37, [dbo].[POHDRF00].[A4GLIdentity] AS t0_r38, [dbo].[POLINF00].[A4GLIdentity] AS t1_r0, [dbo].[POLINF00].[po_no] AS t1_r1, [dbo].[POLINF00].[lin_no] AS t1_r2, [dbo].[POLINF00].[item_no] AS t1_r3, [dbo].[POLINF00].[alt_po_no] AS t1_r4, [dbo].[POLINF00].[alt_lin_no] AS t1_r5, [dbo].[POLINF00].[alt_item_no_1] AS t1_r6, [dbo].[POLINF00].[vend_no] AS t1_r7, [dbo].[POLINF00].[lin_dat] AS t1_r8, [dbo].[POLINF00].[alt_po_no_1] AS t1_r9, [dbo].[POLINF00].[alt_lin_no_1] AS t1_r10, [dbo].[POLINF00].[alt_item_no_2] AS t1_r11, [dbo].[POLINF00].[alt_dat_2] AS t1_r12, [dbo].[POLINF00].[alt_vend_no_2] AS t1_r13, [dbo].[POLINF00].[alt_po_no_2] AS t1_r14, [dbo].[POLINF00].[alt_lin_no_2] AS t1_r15, [dbo].[POLINF00].[item_desc_1] AS t1_r16, [dbo].[POLINF00].[item_desc_2] AS t1_r17, [dbo].[POLINF00].[vend_item_no] AS t1_r18, [dbo].[POLINF00].[vend_item_desc_1] AS t1_r19, [dbo].[POLINF00].[vend_item_desc_2] AS t1_r20, [dbo].[POLINF00].[more_desc_flg] AS t1_r21, [dbo].[POLINF00].[wrksht_no] AS t1_r22, [dbo].[POLINF00].[our_unit] AS t1_r23, [dbo].[POLINF00].[vend_sell_unit] AS t1_r24, [dbo].[POLINF00].[vend_shp_unit] AS t1_r25, [dbo].[POLINF00].[our_conv] AS t1_r26, [dbo].[POLINF00].[vend_conv] AS t1_r27, [dbo].[POLINF00].[sell_shp_conv_flg] AS t1_r28, [dbo].[POLINF00].[qty_ord] AS t1_r29, [dbo].[POLINF00].[unit_prc] AS t1_r30, [dbo].[POLINF00].[deliv_loc_1] AS t1_r31, [dbo].[POLINF00].[deliv_loc_2] AS t1_r32, [dbo].[POLINF00].[deliv_loc_3] AS t1_r33, [dbo].[POLINF00].[deliv_loc_4] AS t1_r34, [dbo].[POLINF00].[deliv_dat_1] AS t1_r35, [dbo].[POLINF00].[deliv_dat_2] AS t1_r36, [dbo].[POLINF00].[deliv_dat_3] AS t1_r37, [dbo].[POLINF00].[deliv_dat_4] AS t1_r38, [dbo].[POLINF00].[deliv_qty_1] AS t1_r39, [dbo].[POLINF00].[deliv_qty_2] AS t1_r40, [dbo].[POLINF00].[deliv_qty_3] AS t1_r41, [dbo].[POLINF00].[deliv_qty_4] AS t1_r42, [dbo].[POLINF00].[deliv_expedite_day_1] AS t1_r43, [dbo].[POLINF00].[deliv_expedite_day_2] AS t1_r44, [dbo].[POLINF00].[deliv_expedite_day_3] AS t1_r45, [dbo].[POLINF00].[deliv_expedite_day_4] AS t1_r46, [dbo].[POLINF00].[deliv_recd_qty_1] AS t1_r47, [dbo].[POLINF00].[deliv_recd_qty_2] AS t1_r48, [dbo].[POLINF00].[deliv_recd_qty_3] AS t1_r49, [dbo].[POLINF00].[deliv_recd_qty_4] AS t1_r50, [dbo].[POLINF00].[deliv_clsd_flg_1] AS t1_r51, [dbo].[POLINF00].[deliv_clsd_flg_2] AS t1_r52, [dbo].[POLINF00].[deliv_clsd_flg_3] AS t1_r53, [dbo].[POLINF00].[deliv_clsd_flg_4] AS t1_r54, [dbo].[POLINF00].[abc_cod] AS t1_r55, [dbo].[POLINF00].[item_typ] AS t1_r56, [dbo].[POLINF00].[vend_item_flg] AS t1_r57, [dbo].[POLINF00].[lin_clsd_flg] AS t1_r58, [dbo].[POLINF00].[blnkt_tot_rel_qty] AS t1_r59, [dbo].[POLINF00].[no_lin_notes] AS t1_r60, [dbo].[POLINF00].[lst_notes_no] AS t1_r61, [dbo].[POLINF00].[edd_dat] AS t1_r62, [dbo].[POLINF00].[timestamp] AS t1_r63, [dbo].[POLINX00].[A4GLIdentity] AS t2_r0, [dbo].[POLINX00].[po_lin_aux_po_no] AS t2_r1, [dbo].[POLINX00].[po_lin_aux_lin_no] AS t2_r2, [dbo].[POLINX00].[po_lin_aux_cont_no] AS t2_r3, [dbo].[POLINX00].[po_lin_aux_wo_no] AS t2_r4, [dbo].[POLINX00].[po_lin_aux_wo_lin] AS t2_r5, [dbo].[POLINX00].[po_lin_aux_qty_shp] AS t2_r6, [dbo].[POLINX00].[po_lin_aux_add] AS t2_r7, [dbo].[POLINX00].[po_lin_aux_unit_prc] AS t2_r8, [dbo].[POLINX00].[po_lin_aux_approved] AS t2_r9, [dbo].[POLINX00].[po_lin_aux_accepted] AS t2_r10, [dbo].[POLINX00].[po_lin_aux_by] AS t2_r11, [dbo].[POLINX00].[po_lin_id] AS t2_r12, [dbo].[POLINX00].[timestamp] AS t2_r13 FROM [dbo].[POHDRF00] INNER JOIN [dbo].[VENFIL00] ON [dbo].[VENFIL00].[vend_no] = [dbo].[POHDRF00].[vend_no] LEFT OUTER JOIN [dbo].[POLINF00] ON [dbo].[POLINF00].[po_no] = [dbo].[POHDRF00].[po_no] LEFT OUTER JOIN [dbo].[POLINX00] ON [dbo].[POLINX00].[po_lin_aux_po_no] = [dbo].[POHDRF00].[po_no] WHERE (VENFIL00.vend_typ=''MFG'') AND (no_open_lins > 0) AND ([lin_clsd_flg] IS NULL OR [lin_clsd_flg] NOT IN (''X'', ''Y'')) ORDER BY po_hdr_dat DESC'
WARN 01:39:33 ubuntu PoHdr[4512]:
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (86.0ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8943'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (86.9ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8932'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (85.5ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8933'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (85.8ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8934'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (85.5ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8935'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (85.2ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8936'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (94.4ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8937'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (89.8ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8938'
DEBUG 01:39:33 ubuntu models[4512]: PoLinx Load (84.1ms) EXEC sp_executesql N'SELECT TOP (1) [dbo].[POLINX00].* FROM [dbo].[POLINX00] WHERE [dbo].[POLINX00].[po_lin_id] = 8939'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment