SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809841 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809841 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88357,109223,966503,645224,795316,96236,30447,861122,247102,901951,240918,585270,304871,704792,597859,803199,589547,736486,1000244,46328,70954,839061,839460,486888,830941,1027158,202342,885364,18023,760102,575369,490866,202128,490494,727191,48361,889047,405949,788123,324058,393874,163729,642075,795337,165805,365749,542007,4798,369569,195230,586118,79002,430952,473157,859222,513932,200877,799612,512155,212724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]