SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331022 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331022 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129889,210754,618660,881479,1012473,737583,977232,224703,199267,782997,571985,439252,114520,13828,342499,13928,426173,357787,429770,267986,602183,889381,910918,956984,242009,615768,1044384,666247,572741,711687,983050,514968,512399,554158,177888,955186,735607,46261,177395,993073,401243,50217,321079,328054,783771,87641,943966,540716,564723,8707,65144,917454,176039,692773,788214,905020,641733,350767,201675,359552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]