SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484084 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484084 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299330,919090,214160,192704,275200,54630,285747,491491,176291,114458,945216,1027169,100060,490566,514286,1042466,469344,172873,816201,579947,496699,506871,763029,188949,726504,708441,333369,956447,824030,330881,135772,946967,598825,923214,213594,1551,1005087,762886,980627,227373,657616,830900,443563,72668,289417,932552,517648,749960,1020721,827776,701225,547977,794832,235820,893912,257015,593219,480719,438598,20097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]