SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 81741 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 81741 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876347,257488,401368,615619,882782,480255,900431,791114,274086,72190,903462,197198,424365,453586,476588,826202,950034,141355,1009690,466138,619619,729107,116697,505286,559775,123487,411595,296890,641454,922198,482260,738718,982704,418247,1033400,914524,541540,694219,31426,618379,150050,111906,150108,91577,903470,749865,740822,293066,451420,880281,117975,782419,1040717,523987,4697,135831,193999,67669,552680,1026898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 81741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 81741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]