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` = 804323 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804323 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450047,92352,61520,712986,325445,618712,922645,1028986,463634,661803,120591,327760,369091,979945,606255,51139,766349,211548,688254,306142,597286,1007316,439072,215442,330747,685422,653448,834024,5826,258903,979201,833385,930731,836527,371714,451461,26031,889158,673906,951498,35131,523401,330135,970463,494995,577504,540734,951169,30094,714110,893214,861298,338709,622726,243579,183782,869734,678887,472757,1028100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]