SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405717 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405717 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709652,96558,1042443,1032689,450286,29097,29704,30935,568140,204248,591618,1043101,965013,296080,140755,821936,80502,10440,791943,801019,870610,428553,341570,962507,755322,789692,648164,559028,780832,466033,835909,995107,380340,344336,838849,617742,567184,483105,490958,394521,307476,4822,84485,308284,52088,511082,899508,587940,253246,55281,505044,485568,920573,587296,114235,828442,601200,1010745,266521,108274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]