SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320069 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320069 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346373,740482,693308,614943,744967,228014,21823,88540,648074,339704,867317,869675,827851,362525,668497,501202,148473,208224,128753,386505,190102,566200,165758,443105,773743,897000,468524,665559,515688,801837,199097,976787,262785,400571,975985,579461,348351,509991,458200,180712,1024095,207488,626140,883478,851487,62565,996569,825800,960708,853918,729797,193902,930568,566248,743736,880476,961214,215509,216072,228863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]