SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240611 LIMIT 1 [ RunTime:0.001870s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240611 [ RunTime:0.005091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648801,928390,561206,28420,259136,131707,811157,14092,472640,746089,701330,581318,1017875,866484,631865,162622,18242,928346,886127,394102,641945,911162,969450,465392,392073,662800,989482,199793,227837,787414,350609,1024125,679126,803733,693496,7588,398503,878245,151999,479512,332566,49293,567742,753412,53897,101943,551065,982812,10054,783107,402886,91713,452732,671333,9912,542308,580358,221912,475793,954876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]