SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541301 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541301 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301858,933488,689156,259893,149233,1025591,69195,259254,56757,270783,451705,153174,214566,13117,694531,604907,749908,527213,81261,565344,882765,186860,74107,821208,464849,546141,38282,715823,131992,519313,996635,5908,821641,622112,692760,713697,451743,90971,164250,20867,114793,171434,1001230,350555,177156,218724,211262,394096,542084,265532,581163,696864,191253,899771,94340,583023,581208,873955,596983,424762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]