SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405790 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405790 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856833,770864,394236,108536,240404,266772,311846,426239,968879,331659,666514,355430,975981,972942,853755,1040859,338173,750257,544642,880930,980224,314311,836548,731923,576819,999962,441087,977681,214303,723160,34508,686335,421109,259108,857807,155776,3847,416536,28380,374611,864108,106473,350765,2887,252685,909213,956834,1006986,65766,425142,425646,310973,137737,559914,282823,304678,1034221,317373,994516,598820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]