SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310708 LIMIT 1 [ RunTime:0.003159s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310708 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402670,379484,349918,80929,237456,478196,86229,801048,320315,719022,665275,951441,622049,583114,469223,362786,318799,188945,96749,54460,433045,854293,104877,1001668,200489,176839,995113,916576,199957,114674,154001,899761,478007,115597,518492,243401,414359,531555,5621,950256,214221,196861,490680,947362,378154,907612,934927,208530,1040142,940374,391949,822889,363498,333267,592418,105769,810145,725144,777216,223867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]