SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514051 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514051 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65838,241225,371421,242835,582609,569970,895368,1003336,700662,936065,1001863,476525,1036062,238361,103320,645618,834932,306375,1031423,863667,965084,283994,351899,116324,58999,38695,2085,469879,183332,870688,639653,963042,173028,375314,966557,912589,789105,833262,860404,92104,635625,599965,789114,780756,998097,396703,464546,318773,680356,978459,474987,891502,1036593,300840,291899,947505,225211,327247,256935,540974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004656s ]