SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 82010 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 82010 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390111,572586,1025059,1029548,781772,1009592,413207,251596,798095,744196,1030502,858253,422287,447645,514651,855826,392458,320741,806815,93336,461226,72042,897395,541142,289318,853772,250989,551408,141055,17441,451506,29879,335868,193814,434173,810691,5212,711747,66637,1039172,879452,853257,287172,546616,65629,206137,589587,245174,509373,614749,886071,474423,462518,373572,651203,310556,908284,472734,658455,553358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 82010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 82010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]