SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409053 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409053 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328989,959905,593152,1026670,466604,203024,71600,92949,950723,195874,528059,1034941,316148,531946,247694,697688,397126,786350,102518,608010,651370,371112,34339,396488,618125,15084,242389,520778,493925,692515,411755,953895,880308,537747,964931,259847,579853,919043,837529,238215,687476,1018215,1045059,804922,181074,696445,527394,515931,508788,972933,613038,154739,570254,929998,879541,110350,419492,627566,797890,685815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]