SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001785s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043849 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043849 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472540,343025,799871,367923,741940,726596,1008115,380167,375028,241555,370731,96239,673774,42990,453413,320244,541940,84119,746709,387545,1036199,587755,703190,179433,954358,577138,790812,860340,835633,696784,899433,656416,1039943,519441,895705,909446,201162,590281,37382,780894,120977,244313,108763,214579,833382,520408,796533,887439,234903,197495,99669,324939,200857,525707,265926,863066,292201,580096,845434,866866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043849 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043849 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]