SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101991 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101991 [ RunTime:0.003089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800712,232688,933008,413053,66724,626709,650531,623985,5581,83966,767880,883580,972781,945235,694275,446414,367341,520808,842438,824862,93029,507490,727847,383423,473679,1014403,600210,223648,266988,627471,420762,110399,572489,433281,656861,963087,201542,472167,538043,461197,631265,491349,720699,956652,961801,380014,405790,244976,760118,622207,936571,703875,481054,292446,887617,452288,511192,643755,243814,73701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000935s ]