SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861482 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861482 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780654,311744,217186,342748,669461,561066,251672,193729,110740,600714,269581,23756,406347,755049,428169,539169,820556,684934,527038,138682,200910,714306,673638,943404,363997,158661,512697,704240,220836,271031,201361,247572,629005,244268,839645,951944,338948,663791,848747,421278,1033168,148101,505240,47382,939216,94566,248555,13787,202737,237526,293391,846449,85828,275766,362864,165251,667013,295715,922293,945089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]