SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416589 LIMIT 1 [ RunTime:0.001085s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416589 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249823,207894,658777,628047,617913,114009,365040,699584,865695,67596,568531,983409,695619,138819,280448,267281,846247,845354,578578,963965,148388,189160,1044097,288697,455683,243317,304071,690138,898087,917005,441925,274163,182375,360199,90186,73101,252446,70045,25836,254653,1003883,413285,855581,844974,644942,539092,203003,699488,876855,529493,623638,259408,754643,331482,420630,582993,570013,556943,79043,890592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]