SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024054 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024054 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165919,543556,321730,985113,424488,703182,932250,415289,153755,514222,499512,213987,505541,906372,243535,1009839,460515,502733,732023,612936,820164,364349,910057,508366,851948,179308,291723,343914,714049,39757,106574,742369,391768,175837,105025,332533,90390,521170,116309,648481,775908,143464,61576,539315,237855,635804,634890,123284,583005,760831,193133,905278,434109,367371,289307,719088,654246,648924,997533,29255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]