SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34201 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34201 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047380,449875,473721,650393,828087,813495,612242,980855,231276,212923,1033174,977615,97448,846453,739769,960928,978600,417719,713600,904024,928609,840598,979119,875124,308238,57201,138613,97228,226702,722639,680601,642526,389735,47318,714371,325942,606136,928472,885841,25765,56973,2810,1017152,932515,248332,66765,964933,455278,973073,466428,995137,982919,938396,752716,426041,582779,714843,210826,78336,495075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]