SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39103 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39103 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728460,473969,790064,271090,721031,612470,997459,221600,345548,489474,793239,960113,40754,841327,864877,910358,6041,727272,731301,968194,814902,607321,499823,35191,564787,978891,521936,453056,928888,31399,522805,1004765,1044119,174637,760558,648360,893273,861667,162808,230600,771231,817829,823503,749428,60699,235432,507208,813481,396776,356507,7760,769352,801679,733950,506598,516093,1196,511949,1019368,371531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]