SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463963 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463963 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966287,287181,1024939,394819,921514,385410,1028200,324376,184887,4835,967359,852190,323659,368431,907684,97794,681597,606960,846313,448539,842529,573140,1048707,783656,977788,396351,849552,1005390,691954,70452,339117,667294,342042,373539,231023,301480,992186,660844,142400,1037060,730955,186231,574597,176968,149309,593530,348083,584642,1037935,791180,585416,843061,36044,945491,523373,29912,997788,272569,610565,792891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]