SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 947481 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 947481 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351640,365233,341256,860240,145970,901755,519431,629897,609005,60734,48201,567102,960901,126790,462607,736245,95815,878719,618185,995284,688887,637608,120014,379869,250775,620026,961912,635460,182594,725786,514981,84630,866915,223246,96993,763826,632748,928089,659174,849609,542347,324760,290640,736587,116481,675312,774220,99161,201744,119185,887691,894419,939354,74246,953633,447126,638630,588434,55343,233238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 947481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 947481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]