SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50776 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50776 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315386,920912,570814,181574,240919,99122,135945,75158,397939,637043,567878,363392,9814,724664,495339,601517,864953,147439,107969,556609,290133,345842,1034217,874157,476683,902942,871867,838760,892115,705880,507242,92019,169593,641514,1042126,234494,198967,491387,595836,989192,38236,810487,541235,670787,95336,767682,310606,986190,283622,143059,77247,242555,789554,802375,439087,601967,676951,203470,786459,334270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]