SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31966 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31966 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392849,989414,989513,975344,870150,409011,821458,922169,1042203,486789,969555,264929,939383,822447,1009667,522717,296059,198145,985099,289849,556525,490495,451870,736247,1008100,415475,1039314,553811,1019720,598490,897376,504637,847526,760989,4654,968388,749920,169639,282230,335298,983856,715524,909122,664667,785708,980346,385855,467279,958148,418990,210432,69337,376651,593744,893300,874977,658373,986021,959642,894740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]