SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 379820 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 379820 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207149,420693,825035,398980,117988,795215,627959,630100,247651,998718,84682,969003,955406,428860,443116,105518,621792,708661,42237,1039,582663,820773,764103,1004362,910181,684610,166238,169682,604439,136877,571801,1032115,142827,562894,901702,835343,17700,662043,308256,738441,780570,619124,853889,665554,156921,902096,1030574,845833,194378,268545,708461,578137,732494,141861,342527,140742,209343,466591,612326,401156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 379820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 379820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]