SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861092 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861092 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337284,117876,425104,858191,669284,33383,672203,294013,760382,986325,120423,906780,1030584,1007401,385619,572890,1010890,987040,630491,878246,56417,609335,586864,502591,546786,339705,409726,553574,426654,455102,711144,256335,1022170,64787,7084,259806,956780,881899,568564,878042,1012975,405477,440329,342608,945267,820227,764904,860514,326706,999321,134111,776029,102682,632131,1026703,435441,614480,401653,521476,542701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001488s ]