SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40712 LIMIT 1 [ RunTime:0.001339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40712 [ RunTime:0.005742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119862,1030892,1030615,190192,904336,145672,814318,992419,353086,426123,449582,978770,83939,656831,405471,441730,563852,817249,419772,743869,529205,834034,514565,896038,675229,687490,32933,920628,651902,976877,509441,541495,837600,114787,784112,559436,290881,825336,6633,743934,640798,248137,19606,749615,342815,1025955,814338,11363,264119,855768,547451,493789,306625,240769,745255,696398,239552,934562,181126,654704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]