SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478343 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478343 [ RunTime:0.003894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015166,115169,77341,489932,168873,774545,839182,657569,334064,70995,436330,138393,81287,893075,909228,350444,799856,632388,1047900,1029136,606915,438728,830226,421632,86208,705388,239406,98925,923349,270154,299600,87132,184342,274056,605468,638107,891751,127855,692467,743256,275723,966189,891373,644745,841836,662801,291410,190952,1026030,652541,573953,37588,1046519,99565,752536,1007129,1017567,458665,946523,268315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]