SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802698 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802698 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728593,624694,746371,406541,409705,730414,643108,414227,456909,780650,187556,357483,930709,381633,50217,1024037,109879,99769,281504,686582,512777,410738,385858,532715,898344,164932,211765,992784,745541,198346,741443,565584,359756,592360,979705,428239,484868,552159,70537,655961,455640,336590,342476,73752,399375,997388,148462,966702,618788,528671,903799,370380,436650,78426,416497,724578,798342,697601,568027,458514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]