SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35140 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35140 [ RunTime:0.004006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86089,941908,907089,292260,978391,899542,1003957,837190,386629,658449,902289,882269,858214,143297,447218,350337,839456,1019643,642920,678127,463327,41885,773140,770319,22263,304841,283987,939246,847356,8470,955741,645751,82735,987955,211024,644188,743732,47923,923513,565206,858669,478439,468024,709121,229145,576889,161862,94384,243441,200421,995067,772395,135307,549450,284273,577004,728365,114174,604642,1019864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001639s ]