SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504835 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504835 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538022,622233,875837,454515,975606,429905,126153,535930,301450,72401,441308,229246,542977,749248,945618,568435,89110,1004879,113743,411099,357557,685367,850779,646214,665405,700219,742467,33667,1001929,858280,508987,954782,114884,470762,576920,367021,191887,679443,990309,629377,197744,20778,487886,894799,393428,816532,307036,1027060,86383,148140,275951,663535,311642,661783,964425,649037,957073,702063,316226,33924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]