SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318670 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318670 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005016,151014,111816,282711,437856,1012379,698131,814358,254374,291187,727358,516170,320682,633987,549866,908632,446435,276705,838607,852082,910044,336021,429672,118226,9797,998788,595798,557994,962405,678760,150505,220952,606876,157513,378595,113685,146664,318980,623924,158977,428348,446647,261957,873688,479595,551934,972022,907839,514641,956755,326758,175052,660852,570238,714796,587562,663545,221978,285459,98912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]