SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536170 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536170 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516982,203269,294705,553708,427231,898287,272448,588811,783048,364165,972028,228017,509149,100427,832006,776007,892439,155729,1019949,284087,168959,347925,493183,642091,8700,510190,620510,1047083,850484,658473,1026746,368089,806263,698261,932423,828454,868707,407714,382561,772640,714335,514354,339910,1021651,155556,483128,951706,108388,380036,799554,85854,1025077,488393,283460,431726,732168,975514,1015000,202814,830256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]