SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322019 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322019 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788890,146068,457560,1037256,475165,377237,411652,963840,946523,899104,958726,816989,354940,311807,423824,371473,144900,78705,31940,459034,777572,451186,572488,360103,970255,492694,649392,905270,258177,555632,1046460,328944,149055,491705,138069,598467,847402,1014918,401450,739310,902390,835171,621383,358113,745676,687064,900614,129719,79306,392952,893016,144390,125403,472815,151943,341832,411303,818420,223317,677347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]