SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013441 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013441 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693561,629335,530760,377549,91026,193804,1032504,1024494,910742,665901,309976,1046905,306462,374488,537462,72510,1030538,210034,954485,320201,1004583,841877,608950,382427,923811,511179,500160,544978,970235,916130,1023349,839020,855001,1036476,961722,827722,236101,474017,260718,506943,889078,623653,70470,602310,312675,150368,496201,5936,49296,207239,814307,328601,883886,153871,604082,31984,31557,351023,656142,500294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]