SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382840 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382840 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137545,383061,898723,711523,204574,902527,291408,983680,18334,258122,649541,159258,734390,702037,166630,828658,527003,998833,760093,624419,794317,945446,602171,966444,915282,131911,1005174,732276,324817,739847,833991,688933,59485,414793,320956,18293,832788,72346,162891,1027696,293481,322847,868654,745945,850124,470148,389100,170349,864025,957479,439726,620340,872359,26733,409714,406479,705919,461233,16069,647119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]