SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261693 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261693 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225720,812987,772492,791028,211442,269431,809889,102844,582,407494,680464,580736,106584,612863,541159,850432,519882,521324,222445,312318,482913,71349,273596,820765,27523,343042,369115,1031002,666622,500830,436518,952975,771447,285858,595717,244299,463621,745906,679737,954911,45420,4658,819473,965858,342337,870359,787785,592440,284216,222808,140600,483240,632867,720692,776095,822410,572481,196667,984035,189918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]